Common questions about LOGINV usually involve parameter errors, unexpected results, and filling formulas across multiple cells; this FAQ includes 3 common answers and a glossary.
FAQ
Why does LOGINV return an error value after I enter it?
- Check whether the parameters used in the formula are numeric rather than text or blank content.
- Confirm that the function name, parentheses, and separators are entered correctly.
- If the formula references other cells, make sure those referenced cells contain valid values.
Why is the LOGINV result different from what I expected?
- Review the parameter order and make sure each value is entered in the intended position.
- Check the referenced cells and ranges to confirm that text values are not being used where numbers are required.
- Open the Insert Function dialog again if you want to review the parameter guidance before recalculating.
How do I use LOGINV in multiple cells at once?
- Enter the LOGINV formula in the first target cell.
- Select that cell and move the pointer to the fill handle in the lower-right corner.
- Drag the fill handle down or across to copy the formula to other cells.
Glossary
| Term | Definition |
|---|---|
| LOGINV | A statistical function used to return the inverse of the lognormal cumulative distribution function. |
| Function arguments | The values or cell references entered into a function so it can calculate a result. |
| Formula bar | The input area above the worksheet where you can view and edit the active cell formula. |