The arguments for the LOGNORM.DIST function are:

Argument | Required? | Description |
---|---|---|

x | Required | The value at which to evaluate the function. |

mean | Required | The mean of ln(x). |

standard_dev | Required | The standard deviation of ln(x). |

Returns the cumulative lognormal distribution of x, where ln(x) is normally distributed with parameters mean and standard_dev.
Use this function to analyze data that has been logarithmically transformed.

LOGNORM.DIST takes 3 required arguments and no optional arguments:

LOGNORM.DIST(x, mean, standard_dev)

The arguments for the LOGNORM.DIST function are:

Argument | Required? | Description |
---|---|---|

x | Required | The value at which to evaluate the function. |

mean | Required | The mean of ln(x). |

standard_dev | Required | The standard deviation of ln(x). |