Forum Discussion

Teresa555's avatar
Teresa555
Copper Contributor
Nov 14, 2023

IFNA Error

When I insert the IFNA formula, it automatically enters a "+" symbol which unables it to function correctly therefore it always comes up as an error. When I delete the "+" symbol, it still appears as an error, and won´t work. In consequence, a  warning appears on my screen telling me to insert an "´" symbol before the IFNA formula, in order to get the function working correctly, I enter it and still doesn´t work. 

1 Reply

  • Teresa555 

    Do you create the formula by starting it with

     

    =IFNA(

     

    For example:

     

    =IFNA(MATCH(A1, D1:D100, 0), "No Match!")

Resources