If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Need formula to round number up to always end in X.X9
I have a spreadsheet with prices. If the price is 2.55, I want the formula
to round it up to 2.59. If it is 3.01, I want the formula to round it to 3.09. The last digit always needs to be a 9, and it always needs to round UP to the next .x9. Any ideas? |
#2
|
|||
|
|||
Need formula to round number up to always end in X.X9
You could use this to round down to the nearest dime:
=FLOOR(A1,0.1) Then add 9 cents =FLOOR(A1,0.1)+0.09 Heather wrote: I have a spreadsheet with prices. If the price is 2.55, I want the formula to round it up to 2.59. If it is 3.01, I want the formula to round it to 3.09. The last digit always needs to be a 9, and it always needs to round UP to the next .x9. Any ideas? -- Dave Peterson |
#3
|
|||
|
|||
Need formula to round number up to always end in X.X9
With your number in A1
=ROUNDUP(A1,1)-0.01 "Heather" wrote: I have a spreadsheet with prices. If the price is 2.55, I want the formula to round it up to 2.59. If it is 3.01, I want the formula to round it to 3.09. The last digit always needs to be a 9, and it always needs to round UP to the next .x9. Any ideas? |
#4
|
|||
|
|||
Need formula to round number up to always end in X.X9
Try the below
=CEILING(A1,0.1)-0.01 If this post helps click Yes --------------- Jacob Skaria "Heather" wrote: I have a spreadsheet with prices. If the price is 2.55, I want the formula to round it up to 2.59. If it is 3.01, I want the formula to round it to 3.09. The last digit always needs to be a 9, and it always needs to round UP to the next .x9. Any ideas? |
#5
|
|||
|
|||
Need formula to round number up to always end in X.X9
=ROUNDUP(A1+0.01,1)-0.01
This adds a penny, rounds up to the next dime, then subtracts a penny. If you don't first add the penny, you could wind up lowering the input value. Ex: 2.60 would round to 2.60 and then you'd deduct the penny to get 2.59. "Heather" wrote: I have a spreadsheet with prices. If the price is 2.55, I want the formula to round it up to 2.59. If it is 3.01, I want the formula to round it to 3.09. The last digit always needs to be a 9, and it always needs to round UP to the next .x9. Any ideas? |
#6
|
|||
|
|||
Need formula to round number up to always end in X.X9
On Thu, 12 Nov 2009 07:42:02 -0800, Heather
wrote: I have a spreadsheet with prices. If the price is 2.55, I want the formula to round it up to 2.59. If it is 3.01, I want the formula to round it to 3.09. The last digit always needs to be a 9, and it always needs to round UP to the next .x9. Any ideas? =CEILING(A1+0.01,0.1)-0.01 --ron |
#7
|
|||
|
|||
Need formula to round number up to always end in X.X9
On Thu, 12 Nov 2009 08:32:10 -0800, Jacob Skaria
wrote: Try the below =CEILING(A1,0.1)-0.01 But 3.60 -- 3.59. If I understand the OP, it should -- 3.69 --ron |
Thread Tools | |
Display Modes | |
|
|