Statistical

PHI Function in Excel

Returns the value of the density function for a standard normal distribution.

Syntax

  • =PHI(x)

Arguments

  • x (required): The number for which you want the density

Examples

  • =PHI(0) - Density at mean - Result: 0.3989
  • =PHI(1) - Density at 1 std dev - Result: 0.2420

PHI for data analysis

  • Confirm whether you need entire columns, filtered subsets, or distinct values.
  • Use [COUNTIFS](/functions/countifs/) and [SUMIFS](/functions/sumifs/) for multi-criteria metrics.
  • Pivot tables complement single-cell statistical formulas for exploration.

Common errors

  • Returns density, not probability

Use cases

  • Statistical modeling
  • Probability density calculations

Frequently asked questions

  • What is the PHI function in Excel? PHI returns the value of the density function for a standard normal distribution. The syntax is =PHI(x). Typical use cases include statistical modeling, probability density calculations.
  • How do I use the PHI function? To use PHI, type =PHI( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
  • What type of data does PHI work with? PHI works with numerical data and can handle ranges, arrays, and individual values. It ignores text values and empty cells in its calculations, focusing only on numeric data for accurate statistical analysis.
  • Why is PHI not working in my Excel? Common issues with PHI include Returns density, not probability. Start by checking the syntax =PHI(x), then verify each referenced cell or range.

Editorial review

  • Reviewed by Excel.Directory Editorial Team. Updated May 2026.