| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Rounding - for retail prices
I am trying to round a set of numbers to "5's and 9's". For example if a
price is $1.44, I would like to to round to $1.45. Or, if a price is $1.88 I would like it to round to 1.89. Thank you! |
|
#2
|
|||
|
|||
|
try this =(INT(E23*10)/10)+(IF(MOD(E23*10,1)*105,9,IF(MOD(E23*10,1)=0,0, 5))/100) -- anilsolipuram ------------------------------------------------------------------------ anilsolipuram's Profile: http://www.excelforum.com/member.php...o&userid=16271 View this thread: http://www.excelforum.com/showthread...hreadid=277249 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Banker's Rounding - need help! | Excel Discussion (Misc queries) | |||
| Can I stop rounding in excel? | Excel Discussion (Misc queries) | |||
| How do I make Excel stop rounding off my numbers that are 16 digi. | Excel Discussion (Misc queries) | |||
| rounding | Excel Worksheet Functions | |||
| Price rounding - exception formula required | Excel Worksheet Functions | |||
Linear Mode
