Excel PI Function

This post will guide you how to use Excel PI function with syntax and examples in Microsoft excel.

Description

The Excel PI function returns the value of mathematical constant PI. The returned value is 3.14159265358979 and ti will accurate to 15 digits.

The PI function is a build-in function in Microsoft Excel and it is categorized as a Math and Trigonometry Function.

The PI function is available in Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000, Excel 2011 for Mac.

Syntax

The syntax of the PI function is as below:

=PI()

The PI function has no any arguments.

Excel PI Function Examples

The below examples will show you how to use Excel PI Function to return the value of PI.

1# get the value of PI, enter the following formula in Cell B1.

=PI()

excel pi examples1

2# get the value of PI divided by 2, enter the following formula in Cell B2.

=PI()/2

excel pi examples2

Related Posts

Calculate the Area in Excel

In Excel, you may compute the area of a parallelogram by using a conventional formula and the multiplication operator. To get the area of a circle, use the PI function and the exponent operator (). Excel has a standard set ...

Excel VDB Function

This post will guide you how to use Excel VDB function with syntax and examples in Microsoft excel. Description The Excel VDB function calculates the depreciation of an asset for a specified period based on the double declining balance method. ...

Excel SYD Function

This post will guide you how to use Excel SYD function with syntax and examples in Microsoft excel. Description The Excel SYD function calculates the sum-of-years’digits depreciation of an asset for a specified period. And it will return a numeric ...

Excel SLN Function

This post will guide you how to use Excel SLN function with syntax and examples in Microsoft excel. Description The Excel SLN function calculates the depreciation of an asset for one period based on the straight line depreciation. And it ...

Excel PV Function

This post will guide you how to use Excel PV function with syntax and examples in Microsoft excel. Description The Excel PV function returns the present value of a loan or investment based on constant payments and a constant interest ...

Comments

So empty here ... leave a comment!

Leave a Reply

Sidebar