Forum Discussion
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 that it the argument separator that needs to be to comma, i have done that but still the problem continues.
e.g. IFERROR(I2*J2,''n.a.'') i get the attached message
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
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
Haytham Amairah Thank you very much :) it worked!
