Forum Discussion
DLogan Group
Jul 09, 2018Copper Contributor
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...
- 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
Haytham Amairah
Jul 09, 2018Silver Contributor
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
- DLogan GroupJul 10, 2018Copper Contributor
Haytham Amairah Thank you very much :) it worked!