| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Function and rounding numbers
Ok, can someone help me out? I am trying to create formula that is
going to round my numbers to x.47 or x.97. A1=$9.99 B1=75% C1=A1-B1=$2.49 So what I am trying to do is to take discount from price and if it ends x.49 I would like to round it x.47 and if it ends x.99 I would like to round it to x.97. Does this make sense….so everything between x.51 and x.99 should be rounded to x.97 and everything between x.01 to x.49 should be rounded to x.47. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rounding numbers | Excel Discussion (Misc queries) | |||
| rounding numbers for match function | Excel Worksheet Functions | |||
| rounding numbers for match function | Excel Worksheet Functions | |||
| Rounding up numbers | Excel Discussion (Misc queries) | |||
| Rounding Numbers | Excel Discussion (Misc queries) | |||
Threaded Mode
