When using FISHER, the most common issues fall into 3 groups: input errors, syntax questions, and unexpected results; this section answers 3 frequent questions.
FAQ
What should I do if the FISHER function returns an error?
- Check whether the formula starts with
=. - Confirm that the function name is spelled
FISHER. - Check whether the parentheses, separators, and argument count are complete.
- Use the syntax prompt that appears during input to correct the formula.
How can I view the FISHER function description?
- Select any cell.
- Type
=FISHER(. - Review the syntax prompt and argument guidance that appears automatically.
- Continue entering or adjusting the formula based on that prompt.
Why does the FISHER result look-incorrect?
- Check whether the referenced cell contains a valid numeric value.
- Confirm that the referenced area does not contain text-formatted numbers or error values.
- Check for an incorrect reference or a problem in the nested formula structure.
- After changing the source data, confirm that the result updates again.
Glossary
| Term | Definition |
|---|---|
| FISHER function | A statistical function that converts a correlation coefficient into a Fisher Z value. |
| Syntax prompt | The parameter format, example, or input guidance shown while a function is being entered. |
| Cross-worksheet reference | A way to use cell data from another worksheet in the current formula. |
| Nested calculation | A combined calculation that places another function or expression inside a function. |