The PHI function returns the value of the density function for a standard normal distribution.

  • This function was introduced in Excel 2013 and so is not available in earlier versions.

Syntax

=PHI(x)

Arguments

Argument Description
x The number for which you want to calculate the density function for a standard normal distribution

Examples

  A B C
1 Formula Result Notes
2 =PHI(0.75) 0.301137432 The value of the density function for a standard normal distribution
3 =PHI(-1.5) 0.129517596  

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if x is using a data type that is not valid
#NUM! Occurs if x is not a valid number