Formulas > =LOGNORM.INV()
How to Use LOGNORM.INV() in Google Sheets
Description
How To Actually Use LOGNORM.INV() in Sheets
LOGNORM.INV(x, mean, standard_deviation)
Try LOGNORM.INV yourself
In cells D1:D10, use the LOGNORM.INV function to calculate the inverse of the log-normal distribution for the values in A1:A10, with a mean of 0 and a standard deviation of 1.
Hints (2)
-
Remember to reference the correct cell for the x value.
-
The mean and standard deviation are constants in this case.
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 BetterSheets.co/formulas
Learn more about the LOGNORM.INV() formula:
Generate a LOGNORM.INV() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses LOGNORM.INV(). 2 free AI generations, no signup. Members get unlimited use.
Generate a LOGNORM.INV() formula