3 different ways to find the Square Root of a Number in Excel

Microsoft Excel is a powerful tool to behaviour out complex calculations. If y'all piece of work on Excel, together with hence y'all mightiness come upward across performing mathematical operations virtually every day. Sometimes, nosotros expression upward problems to produce uncomplicated calculations inward Excel together with to honour foursquare source inward Excel is 1 with them. So, inward this article, I volition allow y'all know of iii unlike ways to find the foursquare source of a number inward Excel.

Calculate Square Root of Number inward Excel

Using SQRT function, POWER role together with Exponential formula, it is slowly to calculate the foursquare source of a pose out inward Excel easily.

1. Use SQRT Function To Find Square Root of Influenza A virus subtype H5N1 Number In Excel

Excel provides SQRT role to honour the foursquare source of a number. It is slowly to usage together with y'all but require to exceed away the pose out or reference of a jail cellphone which has a pose out to SQRT function.

Syntax:

SQRT(number)

But, at that spot is a pocket-sized work with using SQRT directly. If y'all exceed away the negative pose out to SQRT function, together with hence it shows #NUM! error.

So, it is e'er recommended to usage ABS function along with SQRT role equally shown below.

ABS role converts negative pose out to positive pose out i.e; absolute number.

2. Use POWER Function To Find Square Root of Influenza A virus subtype H5N1 Number

POWER role helps y'all to honour the foursquare source of a pose out inward a unlike means when compared to SQRT function. Using this function, nosotros honour a foursquare source of a pose out past times raising the pose out to the Nth power.

Syntax:

POWER (number, power)

Here, the pose out refers to the pose out straight or jail cellphone reference which has a pose out to honour the foursquare source together with ability is the exponent to heighten the pose out to that power.

As nosotros desire to honour the foursquare source of a pose out inward Excel, nosotros tin usage ability equally ‘1/2’ together with the formula becomes POWER (number, 1/2).

3. Use Exponent Operator to Find Square Root of Influenza A virus subtype H5N1 Number

Using Exponent Operator to honour a foursquare source of a pose out is slowly when compared to inward a higher house 2 methods. This is like to POWER, but hither nosotros produce non usage whatsoever function, but but an exponent operator.

Exponent operator allows us to heighten the pose out to whatsoever power. To honour the foursquare source of a pose out inward Excel, nosotros usage ‘(1/2)’ equally the exponent. So, if nosotros accept the pose out inward jail cellphone ‘B2’ then, B2^(1/2) gives foursquare source of a pose out available inward jail cellphone B2.

These are iii unlike ways to honour the foursquare source of a pose out inward Excel easily. Please part with us if y'all accept whatsoever other methods together with allow us know if y'all accept whatsoever to a greater extent than questions.

Read next: How to calculate Sporadic Totals inward Microsoft Excel.

Source: https://www.thewindowsclub.com/

Share This :