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 cell = C12)
Bonus amount ($50 FOR PART TIME, $200 FOR FULL TIME )
Example:
Sales target is $50,000. If an employee is part time and the store exceeds the target, they will receive a bonus of $50. If it doesn't reach the target, there is no bonus. This is the same for a full time employee except they receive a $200 bonus.
Currently I have entered the formula as follows"
=IF(AND(D10>D9,C12=PT),"$50.00","$0")
Any advise?
Thanks
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!
- OK, that worked. So how do I add the bonus if they are full time? That is another criteria.
You can depend on this formula:
=IF(B1>B2,IF(B3="PT",50,200),"")
Please find the attached file.
Regards
