sqrt

 Here are 10 examples of how to use the SQRT function in Excel, including sample data and formulas:

---

1. Basic Square Root Calculation

• Data: 25 in cell A1

• Formula: =SQRT(A1)

• Result: 5 (since √25 = 5)

---

2. Square Root of a Sum

• Data: 9 in cell A1, 16 in cell A2

• Formula: =SQRT(A1 + A2)

• Result: 5 (since √(9 + 16) = √25 = 5)

---

3. Square Root of a Product

• Data: 4 in cell A1, 25 in cell A2

• Formula: =SQRT(A1 * A2)

• Result: 10 (since √(4 * 25) = √100 = 10)

---

4. Square Root of a Division

• Data: 100 in cell A1, 4 in cell A2

• Formula: =SQRT(A1 / A2)

• Result: 5 (since √(100 / 4) = √25 = 5)

---

5. Square Root with Exponentiation

• Data: 3 in cell A1

• Formula: =SQRT(A1^2)

• Result: 3 (since √(3²) = 3)

---

6. Square Root of a Negative Number (Error Handling)

• Data: -16 in cell A1

• Formula: =IF(A1 < 0, "Invalid Input", SQRT(A1))

• Result: Invalid Input (since √(-16) is not a real number)

---

7. Square Root of an Average

• Data: 4 in cell A1, 9 in cell A2, 16 in cell A3

• Formula: =SQRT(AVERAGE(A1:A3))

• Result: 3 (since the average of 4, 9, and 16 is 9.666..., and √9.666... ≈ 3.11)

---

8. Square Root with Rounding

• Data: 10 in cell A1

• Formula: =ROUND(SQRT(A1), 2)

• Result: 3.16 (since √10 ≈ 3.162, rounded to 2 decimal places)

---

9. Square Root in a Conditional Formula

• Data: 25 in cell A1

• Formula: =IF(A1 > 0, SQRT(A1), "Invalid Input")

• Result: 5 (since 25 > 0, the formula calculates √25)

---

10. Square Root of a Dynamic Range

• Data: 4 in cell A1, 9 in cell A2, 16 in cell A3

• Formula: =SQRT(SUM(A1:A3))

• Result: 5.385 (since √(4 + 9 + 16) = √29 ≈ 5.385)

---

These examples demonstrate the versatility of the SQRT function in Excel, including combining it with other functions like SUM, AVERAGE, IF, and ROUND