| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
rounding to a specific number
Assume the unrounded price (e.g., 123.34) is in cell A1.
=IF(MOD(A1*100,10)5,TRUNC(A1,1)+0.09,TRUNC(A1,1)-0.01) "reno" wrote: when caluclating retail prices, with various costs and various gross margins want to make the calculation and then the last digit ends in say 9. So if actual calculation's last digit is 0-5 it would round down to nearest 9; or 5 rounds up to next 9. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I find an average number of specific words in a column | New Users to Excel | |||
| specific rounding of formulas which may need to include an IF stat | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
| Rounding a number to a multiple quantity that adds to a fixed total number | Excel Worksheet Functions | |||
| Returning the Week Number of a Specific Date on a Month | Excel Worksheet Functions | |||
Linear Mode
