When using FACTDOUBLE, the most common questions fall into 3 areas: argument errors, unexpected results, and filling the formula across multiple cells.
FAQ
Why does FACTDOUBLE show a #VALUE! error?
- Check whether the argument is a numeric value.
- Make sure the source cell does not contain extra spaces or text characters.
- Clean the original data if needed, then enter the formula again.
Why is the FACTDOUBLE result different from what I expected?
- Check whether the referenced cell is correct.
- Confirm that the input is stored as a number instead of text.
- Review the formula again and verify the argument step by step.
How do I use FACTDOUBLE in multiple cells?
- Enter the correct FACTDOUBLE formula in the first cell.
- Select that cell and move the pointer to the fill handle in the lower-right corner.
- Drag downward or sideways to copy the formula to the target range.
- Adjust the reference style if you need to keep a reference fixed.
Glossary
| Term | Definition |
|---|---|
| FACTDOUBLE | A function that returns the double factorial of a number. |
| Insert Function | An entry that lets you search for, select, and insert a function from a dialog box. |
| Function Arguments | The input values required for a function to calculate a result. |
| Formula bar | The area where you can view and edit the current cell content or formula. |