Forum Discussion
Help with Formula
bam_13 wrote: ``the formula is showing in the cell instead of the result (IFERROR(IF(B17,B17*F17,""),"")``
First, confirm that you mistyped in the posting, and the cell content is actually
=IFERROR(IF(B17,B17*F17,""),"")
Based on that assumption, verify that the cell is (or was !) formatted as Text.
If the cell was formatted as Text when you entered the formula, then you reformatted the cell to non-Text, you must re-enter the formula in order to remove the text type.
You might "re-enter" the formula by simply selecting the cell, pressing the f2 key, then pressing Enter.
bam_13 wrote: ``the formula is showing in the cell instead of the result (IFERROR(IF(B17,B17*F17,""),"")``
First, confirm that you mistyped in the posting, and the cell content is actually
=IFERROR(IF(B17,B17*F17,""),"")
Based on that assumption, verify that the cell is (or was !) formatted as Text.
If the cell was formatted as Text when you entered the formula, then you reformatted the cell to non-Text, you must re-enter the formula in order to remove the text type.
You might "re-enter" the formula by simply selecting the cell, pressing the f2 key, then pressing Enter.
- Thank you, you're right the cell was in text format
