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

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

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