Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get formula result of 3.56 to round up to 4 automatic?
If my formula is K9*7/250=3.56, how do I get the result of 3.56 to round up
automatically to 4.0???? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get formula result of 3.56 to round up to 4 automatic?
Try this:
This formula uses 5/4 rounding (up/down), respectively =ROUND(K9*7/250,0) Or If you always want to round UP to the next highest integer =CEILING(K9*7/250,1) Does that help or do you need something else? *********** Regards, Ron XL2002, WinXP "Sharon D" wrote: If my formula is K9*7/250=3.56, how do I get the result of 3.56 to round up automatically to 4.0???? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get formula result of 3.56 to round up to 4 automatic?
Hi Sharon
Try =ROUND(K9*7/250,0) If you want the cell to display 4.0 rather than 4, format the cell to decimal place. -- Regards Roger Govier "Sharon D" <Sharon wrote in message ... If my formula is K9*7/250=3.56, how do I get the result of 3.56 to round up automatically to 4.0???? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The Formula is displaying, not the result | Excel Discussion (Misc queries) | |||
how do I round up a result of a formula in Excel | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Median result used in formula gives incorrect result | Excel Worksheet Functions | |||
Amount or Numbers in Words | New Users to Excel |