Как пользоваться функцией SQRTPI в Excel
| Русский | Английский |
|---|---|
| КОРЕНЬПИ | SQRTPI |
The SQRTPI function in Excel and Google Sheets returns the square root of the product of the number Pi and a given number.
Syntax
The syntax for the SQRTPI function is:
SQRTPI(number)number — The number to multiply by Pi and then calculate the square root of.
Usage Examples
Example 1: Calculating the square root of the product of Pi and the number 10
To calculate the square root of the product of Pi and the number 10 in Excel and Google Sheets, use the following formula:
| Input | Formula | Result |
|---|---|---|
| 10 | =SQRTPI(10) | 5.012 |
Example 2: Calculating the square root of the product of Pi and the number 20
To calculate the square root of the product of Pi and the number 20 in Excel and Google Sheets, use the following formula:
| Input | Formula | Result |
|---|---|---|
| 20 | =SQRTPI(20) | 7.089 |
The SQRTPI function enhances mathematical operations in Excel and Google Sheets, allowing for quick and convenient computation of the square root of the product of the number Pi and a specified number.
Больше информации: https://support.microsoft.com/ru-ru/office/функция-кореньпи-1fb4e63f-9b51-46d6-ad68-b3e7a8b519b4