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????
S Sharon D Sep 13, 2006 #1 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????
R Ron Coderre Sep 13, 2006 #2 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
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
R Roger Govier Sep 13, 2006 #3 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.
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.
