ROUNDDOWN formula

=ROUNDDOWN(A2,1)
The excel formula above rounds the value in cell A2 down 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 rounddown formula is 1.2. The comma followed by the number one in the formula above tells excel to round the value in A2 down by 1 decimal place.

Read More..

Power formula

=POWER(2,3)
The excel formula above is stating the same as 2 to the power of 3. Or =2^3. It basically takes the 2 and multiplies it by itself 3 times. So it would be the same as 2 x 2 x 2, which is 8.

Read More..

ROUNDUP formula

=ROUNDUP(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 roundup 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.

Read More..