| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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) | |||
Hybrid Mode
