Forum Discussion

bam_13's avatar
bam_13
Copper Contributor
Jan 12, 2024
Solved

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,""),"")
Formulas and Functions
  • JoeUser2004's avatar
    JoeUser2004
    Jan 12, 2024

    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.

JoeUser2004's avatar
JoeUser2004
Bronze Contributor
Jan 12, 2024

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.

Resources