Forum Discussion

DLogan Group's avatar
DLogan Group
Copper Contributor
Jul 09, 2018

IFERROR formula

Hi guys   Every time i punch in a logical formula in my excel it always gives me this messages that there is something wrong with my formula even though my formula is correct. Initially i advised t...
  • Haytham Amairah's avatar
    Jul 09, 2018

    Hi,

     

    The cause of this problem is the wrong text wrapper!
    You have to wrap the texts in formulas with double quotes "text".
    What you typed in the formula you mentioned isn't double quotes, you repeated the single quote twice!

    In order to get the actual double quotes, you have to press the Shift key along with the Quote key in the keyboard.

     

    Regards

Resources