 Description

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

• What is the LOGINV formula?
• How is the LOGINV formula used?
• What are some examples of when to use the LOGINV formula?

How can the LOGINV formula be used appropriately?
The LOGINV formula can be used to calculate the natural logarithm of the inverse of an x-value you specify. This is most commonly used to calculate probability distributions, like the Poisson and Binomial distributions.

How can the LOGINV formula be commonly mistyped?
The LOGINV formula is sometimes mistaken for the LOGINVERSE formula. This is usually due to similarities in name and function. Other misspellings are LOGIN, LOGNV, LOIGNV, LOGINB.

What are some common ways the LOGINV formula is used inappropriately?
The LOGINV formula should not be used to calculate logarithms of numbers other than the inverse of x-values. Additionally, it should not be used to calculate logarithms of exponents, angles or other non-inverse variables.

What are some common pitfalls when using the LOGINV formula?
• Ensuring that the syntax of the formula is correct.
• Using the correct inverse x-value.
• Making sure that the values input into the formula are in the correct format.

What are common mistakes when using the LOGINV Formula?
• Using the wrong variables in the formula.
• Inputting incorrect values for the arguments.

What are common misconceptions people might have with the LOGINV Formula?
• Believing that the LOGINV formula can calculate logarithms of numbers other than the inverse of x-values.
• Thinking that the LOGINV formula can be used to calculate logarithms of exponents, angles or other non-inverse variables.

How To Actually Use LOGINV() in Sheets

`LOGINV(x, mean, standard_deviation)`

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

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members. Free to try for non-members.

Asa

Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.

Better Sheets