Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
=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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
=roundup(I4*2,-3)
-- HTH RP (remove nothere from the email address if mailing direct) "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? |
#5
|
|||
|
|||
I tried adding =ceiling(I4,1000) after the I4*2 and it did not work.
I4*2=ceiling(I4,1000). Any other ideas?? "N Harkawat" wrote: =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? |
#6
|
|||
|
|||
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? |
#7
|
|||
|
|||
No, in place of
=CEILING(I4*2,1000) -- HTH RP (remove nothere from the email address if mailing direct) "Katiemcgi" wrote in message ... I tried adding =ceiling(I4,1000) after the I4*2 and it did not work. I4*2=ceiling(I4,1000). Any other ideas?? "N Harkawat" wrote: =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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
How to add 4 of 5 highest numbers using a formula | Excel Discussion (Misc queries) | |||
Price rounding - exception formula required | Excel Worksheet Functions |