Question

What formula would you enter in Excel to calculate the reciprocal of a number?

1) =1/A1
2) =A1/1
3) =1/A1*100
4) =A1/100

Answer 1

The formula to calculate the reciprocal of a number in Excel is =1/A1.

Step-by-step explanation:

The formula to calculate the reciprocal of a number in Excel is =1/A1. This formula divides the number in cell A1 by 1, resulting in the reciprocal of that number. For example, if cell A1 contains the number 5, entering =1/A1 in another cell will give you the reciprocal of 5, which is 0.2.