Truncate to 1 decimal place formula

Let's say the cell reference of A2 below has a value of 111.13:
=trunc(A2,1)
The value that would be displayed as a result of the formula above would be. 111.1. The number 1 after the cell reference of A2 and the comma is telling excel to truncate the value of 111.13 back 1 decimal place. Giving 111.1

Read More..

Convert Number to Words (Indian Format)

How to create the sample function Called SpellNumber

1. Start Microsoft Excel.
2. Press ALT+F11 to start the Visual Basic Editor.
3. On the Insert menu, click Module.
4. Type the following code into the module sheet.

Read More..

Truncate to 2 decimal places formula

Let's say the cell reference of A2 below has a value of 1.13:
=trunc(A2,2)
The value that would be displayed as a result of the formula above would be. 1.13. The number 2 after the cell reference of A2 and the comma is telling excel to truncate the value of 1.13 to 2 decimal places. Giving 1.13.

Read More..

RAND formula rounded to 0 decimal place

=ROUND(RAND() * (65-1) +1,0)
The excel formula above will generate random numbers between 1 and 65 as you fill it down an excel spreadsheet.  The (65-1)+1 bit tells excel to only select numbers between 1 and 65. Simplified it would be (higher number - lower number) + lower number. The RAND()* part randomises the numbers in the range.  The ROUND(...,0) part rounds the random numbers to zero decimal place.  A sample result would be 57 or 1.

Read More..

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..