PHI function

The PHI function returns the value of the density function for a normal distribution with mean 0 and standard deviation 1, calculated with the formula .

Parts of a PHI function


Parts Description
x The input to the standard normal distribution function.

Sample formula



This is a special case of the NORMDIST function, where mean is 0, standard deviation is 1, and 'cumulative' is false.


  A B
1 Formula Result
2 =PHI(0.5) 0.3520653268
3 =PHI(1) 0.2419707245
4 =PHI(1.5) 0.1295175957

Related functions

  • STDEV: The STDEV function calculates the standard deviation based on a sample.
  • NORMDIST: The NORMDIST function returns the value of the normal distribution function (or normal cumulative distribution function) for a specified value, mean, and standard deviation.
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Clear search
Close search
Google apps
Main menu