Forum Discussion
IF FORMULA ERROR
I am having a problem inputting the following information into excel. I keep getting the #NAME? error. Sales target (Excel cell = D9) Actual target (Excel cell = D10) Employee status (Excel cel...
Hi,
Please note that any text inside a formula must be surrounded by double quotes "text".
So, please replace this:
=IF(AND(D10>D9,C12=PT),"$50.00","$0")
With this:
=IF(AND(D10>D9,C12="PT"),"$50.00","$0")
Regards
Awesome...thanks so much!