Thankyou. It works beautifully. All set.
"N Harkawat" wrote:
Yes it is possible to have both formulas in one cell
=Ceiling(I4*2,1000)
"N Harkawat" wrote in message
...
=ceiling(a1,1000) to round up and
=Floor(a1,1000) to round down
"Katiemcgi" wrote in message
...
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?
|