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