| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Round to .99?
Hello, does anyone know if a function will work so that I can round a number
UP to the nearest ending of .99? So if a number is 7.60 it would round to 7.99 or if a number is 7.01 it would round to 7.99? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Round to .99?
I found the answer after searching further. Sorry for posting!
"WBTKbeezy" wrote: Hello, does anyone know if a function will work so that I can round a number UP to the nearest ending of .99? So if a number is 7.60 it would round to 7.99 or if a number is 7.01 it would round to 7.99? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Round to .99?
Try this:
=CEILING(A1+0.01,1)-0.01 -- Biff Microsoft Excel MVP "WBTKbeezy" wrote in message ... Hello, does anyone know if a function will work so that I can round a number UP to the nearest ending of .99? So if a number is 7.60 it would round to 7.99 or if a number is 7.01 it would round to 7.99? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Don't Round... | Excel Discussion (Misc queries) | |||
| round down? | Excel Discussion (Misc queries) | |||
| Round hh:mm:ss to whole hh:mm | Excel Worksheet Functions | |||
| VBA round | Excel Discussion (Misc queries) | |||
| How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions | |||
Linear Mode
