My formula is the following
Cell 1 has the number 3. I would put the following formula in Cell 2 =A1*.20+A2. The number would come out to be 3.6. How can I use this formula and round the number up automatically??
2007-03-06 14:56:17 · 4 answers · asked by drunkviking11 1 in Computers & Internet ➔ Software
You can give the cell that holds your result, the property to have no decimal places. For example, if you cell's property is set to have several decimal places, the result would display 3.5257 or whatever. With one decimal place, it would be 3.6, and if you have no decimal places, then the result, regardless of the formula, would have to display 3.
I hope that makes sense.
2007-03-06 15:06:45 · answer #1 · answered by K.B. 4 · 0⤊ 0⤋
Go with Math Guy's answer he's absolutley correct. I'm a MOS Master Instructor and he even got the extra credit answer right. Way to go Math Guy :-))
2007-03-06 15:06:09 · answer #2 · answered by Deborah A 3 · 0⤊ 0⤋
Use the round function (rounding to the closest value)
=Round(A1*.20+A2,0)
If you always want the ceiling (rounding up)
=Ceiling(A1*.20+A2,0)
2007-03-06 15:01:50 · answer #3 · answered by Math Guy 4 · 1⤊ 0⤋
Try using the "ROUNDUP" function around the whole formula
2007-03-06 14:59:50 · answer #4 · answered by sw_mn_techguy 3 · 0⤊ 0⤋