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????
|