View Single Post
  #1   Report Post  
Katiemcgi
 
Posts: n/a
Default Rounding to the next highest 1000 after a resulting formula

I need to have a column rounding up to the next highest 1000 after a resulted
formula.

ie, I4*2 = $100,200

I need the result to round to $101,000 But, the formula keeps adding the
Roundup formula resulting in 201,200.

Can I have both formulas in one cell?