Saturday, November 24, 2012

Round formula

=Round(A2,1)
The excel formula above rounds the value in cell A2 up by 1 decimal place. Let's say the value in A2 is 1.27. Well the value that will be displayed as a result of the round formula is 1.3. The comma followed by the number one in the formula above tells excel to round the value in A2 up by 1 decimal place.

0 comments:

Post a Comment

www.cineclouds.com. Powered by Blogger.