| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding decimal
Working on a spread sheet that I would like a set cell (example $10.01) to be
rounded to the nearest $.95, $.50. $25. I'm want to round on my pricing to these amounts. Thanks for your help. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rounding decimal
Ok, assuming I understand your criteria correctly, that you want all prices
to round to the NEAREST of these 3 possibilities (.25, .50, .95) then this should work: =IF(A1-INT(A1)<=0.1,INT(A1)-0.05,IF(A1-INT(A1)<=0.375,INT(A1)+0.25,IF(A1-INT(A1)<=0.735,INT(A1)+0.5,INT(A1)+0.95))) HTH, Elkar "Sturart" wrote: Working on a spread sheet that I would like a set cell (example $10.01) to be rounded to the nearest $.95, $.50. $25. I'm want to round on my pricing to these amounts. Thanks for your help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Decimal Places - Settings for Auto Rounding Up/Down | Excel Worksheet Functions | |||
| how to loose all numbers after decimal (not rounding) | Excel Worksheet Functions | |||
| Formula for: Format Decimal places? | Excel Discussion (Misc queries) | |||
| FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
| Decimal places and rounding up (or down) | New Users to Excel | |||
Hybrid Mode
