Forum Discussion
Help with Formula
After apply the formula in the cell, the result is not showing in the cell, the formula is showing in the cell instead of the result (IFERROR(IF(B17,B17*F17,""),"")
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.
5 Replies
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
bam_13 Not sure why you would need IFERROR here, but try entering:
=IFERROR(IF(B17,B17*F17,""),"")
But this will return the same result:
=IF(B17,B17*F17,"")
Riny_van_Eekelen wrote: ``this will return the same result: =IF(B17,B17*F17,"")``
Not if B17 contains an Excel error (e.g. #VALUE) or B17 is text
that Excel cannot convert to a numeric value.ERRATA: IF(B17,...) returns #VALUE for any text in B17, even "numeric" text.
JoeUser2004 Pffffff
