| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
rounding a number created by a formula to a retail price
I want to round a price that i have created by using a formula to .09, .19,
..29, ......99. Example - the price I created by using a formula is $5.64 and I would like to round it to $5.59 or $5.69. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
rounding a number created by a formula to a retail price
Try:
=ROUND(A1+0.01,1)-0.01 Scott Jack wrote: I want to round a price that i have created by using a formula to .09, .19, .29, ......99. Example - the price I created by using a formula is $5.64 and I would like to round it to $5.59 or $5.69. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
rounding a number created by a formula to a retail price
=ROUNDDOWN(A1,1)+0.09
"Jack" wrote: I want to round a price that i have created by using a formula to .09, .19, .29, ......99. Example - the price I created by using a formula is $5.64 and I would like to round it to $5.59 or $5.69. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
rounding a number created by a formula to a retail price
Assuming nothing happens to 0
=MAX(0,ROUND(your_formula,1)-0.01) -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Jack" wrote in message ... I want to round a price that i have created by using a formula to .09, .19, .29, ......99. Example - the price I created by using a formula is $5.64 and I would like to round it to $5.59 or $5.69. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for rounding number to nearest hundred? | Excel Discussion (Misc queries) | |||
| Retail Price rounding help needed | Excel Worksheet Functions | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Value between 2 dates | Excel Worksheet Functions | |||
| Computing Sales Tax and Retail Price from a number | Excel Worksheet Functions | |||
Linear Mode
