## Square and Square Root of a Number in Excel

Calculate the Square of a Number The following are 3 different formulas to calculate the Square of the number in the cell B3 Formula 1 =B3*B3 Formula 2 =POWER(B3,2) Formula 3 =B3^2 Calculate the Square Root of a Number The following are 3 different formulas to calculate the Square Root of the number in the…

## Excel Formula to Convert Numbers to Words

Have you ever thought of an Excel formula that will convert Numbers to Words? i.e. A formula that can convert the number 456,571 into Four Hundred and Fifty Six Thousand Five Hundred and Seventy One. In this blog post, I am sharing two Excel formulas that can convert Numbers in Words. Pete M’s Formula =CHOOSE(LEFT(TEXT(A1,”000000000″))+1,,”One”,”Two”,”Three”,”Four”,”Five”,”Six”,”Seven”,”Eight”,”Nine”)&IF(–LEFT(TEXT(A1,”000000000″))=0,,IF(AND(–MID(TEXT(A1,”000000000″),2,1)=0,–MID(TEXT(A1,”000000000″),3,1)=0),”…

## Interpolation in Excel

You are given the X, Y Coordinates of 2 points, (99.5,39.5) and (201.1,45.7) and asked to find the Y coordinate of an intermediate point with an X coordinate of 115.7. How will you solve this problem? The answer is Interpolation! Interpolation is the method of estimating ‘unknown values’ that fall between ‘known values’. In this…

## Pick a random value from a list in Excel

In this blog post, I will explain two Excel formulas that can be used to pick a random value from a List. Following is a list of 6 contestants for a particular game. For each round of the game, a player should be randomly selected from this list. Let’s see how to pick a random…