Home |
Search |
Today's Posts |
#1
|
|||
|
|||
HOW DO I FORMULATE A CELL TO ROUND $5.82 TO $5.85
In making price lists, I want my prices to round to the nearest .x5 or .x9 .
The cells containing the prices are from a formula in another cell. |
#2
|
|||
|
|||
"rikg" wrote in message ... In making price lists, I want my prices to round to the nearest .x5 or .x9 .. The cells containing the prices are from a formula in another cell. I'm not sure I understand what you want. I think 5.82 should be rounded to 5.8. If you want to round to the nearest 5 cent, use =ROUND(A1*20,0)/20 /Fredrik |
#3
|
|||
|
|||
Assuming your price is in cell A1, put this in B1
=IF(RIGHT(TEXT(A1,"$0.00"),1)/100<=0.05,A1-RIGHT(TEXT(A1,"$0.00"),1)/100+0.0 5,A1-RIGHT(TEXT(A1,"$0.00"),1)/100+0.09) All on one line, watch out for email word-wrap.......... Vaya con Dios, Chuck, CABGx3 "rikg" wrote in message ... In making price lists, I want my prices to round to the nearest .x5 or .x9 .. The cells containing the prices are from a formula in another cell. |
#4
|
|||
|
|||
Try this:
=TRUNC(A1*10)/10+IF((MOD($A1,0.1)+0.01)<=0.06,0.05,0.09) Does that help? Regards, Ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
AutoFIll -by dragging the bottom-right corner of the cell | Excel Discussion (Misc queries) | |||
how to create a variable column in cell reference | Excel Worksheet Functions | |||
How can I get a cell locked if the condition is false? | Excel Worksheet Functions | |||
Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) |