And I guess I didn't answer the nesting issue:

=ROUND(SUM(A1:A100),-3)

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Alabama" wrote:

I am having a problem nesting this calculation, in addition the final sum
should be rounded to 34k....do not know where I am going wrong



Example:

Payment Gross Up Sum Rounded
32,549.00 976.47 33,525.47 30,000.00