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

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)

On Jul 1, 8:49*am, ggrott wrote:
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

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


Replace @mailinator.com with @tiscali.co.uk


"ggrott" wrote in message
...
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

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" wrote:

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

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

"ggrott" wrote:

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