Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to use function ceiling??
got a problem with function ceiling, my formula is =ceiling(A1,1)
A1 = 15 my result is = 15 but if i change my A1 to = 15.01 my result is = 16 but i want my result like this if A1 = 15.01 -- 15.09, i want my result to be 15 but if my A1 = 15.1 and above, i want my result to be 16 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Roundup or Ceiling Function to round to a specific number | Excel Discussion (Misc queries) | |||
modified CEILING function?? | Excel Worksheet Functions | |||
how to use the ceiling function | Excel Worksheet Functions | |||
Round/Ceiling on an IF function returning numerical value or text | Excel Worksheet Functions | |||
Max, Ceiling, If, Etc | Excel Discussion (Misc queries) |