Formula does not calculate

[ggrott]

Can anyone figure out why this formula only calculates part of the formula?
=-ROUND((4.56*G53/1000)+(500*(G23+G39))*20,-4)/20 it only does the
calculations for the second half. I use excel 2000 Thanks

 

[Tim879]

Looks like it has to do with your Round(xxxx, -4).

If you remove the -4 or change it to 1, 0, etc. it works. You're
formulas also work with really large numbers. It maybe that whatever
result you're returning does is not large enough to show 4 places
(i.e. it's less that $10k)

 

[Sandy Mann]

What is in G53? If G53 has zero or is epty then the first part will
evaluate to zero

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Mike H]

Hi,

It's not clear what precedence you want in you formula but you're using -4
for the Round so if you leave G23 and G29 blank you will only start to see
results for the first part (G53) with large numbers in G53.

Mike

 

[ggrott]

Thanks everyone...I think Tim answered the question. I just copied the
formula from my worksheet, that is why you see the cell addresses.