Hi,

You didn't give any rules for the rounding - up or down or nearest so I'll
guess nearest 1000 so with the sum of your numbers in C2 try this

=ROUND(C2/1000,0)*1000

Mike

"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