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...
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