Formulas > =PHI()

How To Use PHI() Function in Google Sheets


The PHI function returns the value of the normal distribution with mean 0 and standard deviation 1.

Common questions about the PHI formula include: What is the PHI formula? What are the components of the PHI formula? How do I set up a PHI formula? 

The PHI formula can be used to calculate the cost of production given inputs such as inventory, total cost of production, and total sales. It can also be used to calculate total sales given input for inventory, total cost of production, and unit cost of production.

The PHI formula can be commonly mistyped, as it has multiple components and sub-components. Potential mistakes include incorrect symbols being used, incorrect placement of parentheses, incorrect terms being used, and incorrect number of arguments being used.

Some common ways the PHI formula is used inappropriately include using it to calculate average cost of production and using it to calculate average inventory. 

Common pitfalls when using the PHI formula include using incorrect terms, such as using cost instead of price when calculating total sales, and forgetting to include one of the components in the formula.

Common mistakes when using the PHI Formula include not accounting for all inputs when constructing the formula, overlooking mathematical operators, and failing to make necessary adjustments to obtain the desired output.

Common misconceptions people might have with the PHI Formula include thinking it’s only used for cost of production calculations, that it’s only used in Google Sheets, and that it’s the same as the CVP (cost, volume, profit) formula.

How To Actually Use PHI() in Sheets


Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the PHI() formula:

Google Sheets PHI NORMDIST Taylor Maclaurin SERIESSUM Expansion LINEST Polynomial Regression

This video shows the use of SERIESSUM int Taylor Maclaurin Series Expansion of PHI function and LINEST for its Polynomial Regression

Generate a PHI() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members. Free to try for non-members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.