Formulas > =LOGINV()

How to Use LOGINV() in Google Sheets

Description

Returns the value of the inverse log-normal cumulative distribution with given mean and standard deviation at a specified value.

How To Actually Use LOGINV() in Sheets

LOGINV(x, mean, standard_deviation)

Try LOGINV yourself

In cells D1:D10, use the LOGINV formula to calculate the inverse log-normal value for each corresponding value in A1:A10, with a mean of 0 and a standard deviation of 1.

Your formula

Hints (2)

Locale Separator ,

Official Docs

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

Transcript-matched member videos for LOGINV(). Click through to watch.

Watch more tutorials

Write Apps Script to Create a New Google Sheets Formula

Create a brand new custom formula in Apps Script. We'll do this for our ...

Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets.

There was a stories craze. Every app/platform/business was adding 24 hou...

CONCATENATE() IF() IMAGE() INDEX() ISBLANK() +1 more

Unlock these tutorials

Learn more about the LOGINV() formula:

Generate a LOGINV() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses LOGINV(). 2 free AI generations, no signup. Members get unlimited use.

Generate a LOGINV() formula

How to Use LOGINV() in Google Sheets

Try LOGINV yourself

More related tutorials

Write Apps Script to Create a New Google Sheets Formula

Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets.