| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Roundup to .99 endings
mj99 wrote:
Trying to get every number in an excel file to roundup for retail price points.... 20.34 = 20.99 38.75 = 38.99 =INT(price) + 0.99 That will change $20 to $20.99. Is that what you want? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to use roundup | Excel Discussion (Misc queries) | |||
| Roundup to the nearest number that is divisible by 3 | Excel Worksheet Functions | |||
| How do I apply the ROUNDUP formula to a range of calculated data | Excel Worksheet Functions | |||
| How do I use Roundup in a logical test in excel | Excel Worksheet Functions | |||
| roundup seconds to minute | Excel Worksheet Functions | |||
Threaded Mode
