PDA

View Full Version : Make Excel lose its decimal place?



jpinard
06-12-2005, 09:12 PM
So if Excel does an average and you have it round 10.56 to 11 in your column ........... If I use that "11" for another equation... how can I make Excel forget the fact it's truly "10.56"?

It's for a freind that golf's and he needs it for calculating handicaps etc and the extra decimal places messes this up.

XPav
06-12-2005, 09:31 PM
In the formula, use CEILING.

http://www.techonthenet.com/excel/formulas/ceiling.htm

jpinard
06-12-2005, 11:01 PM
In the formula, use CEILING.

http://www.techonthenet.com/excel/formulas/ceiling.htm

Thank you sooo much! :D got it working!