Forum Discussion

Terri-Lynn Mcgrath's avatar
Terri-Lynn Mcgrath
Copper Contributor
Jul 13, 2018

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...
Formulas & Functions
Need Help
Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Jul 13, 2018

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

 

 

  • Terri-Lynn Mcgrath's avatar
    Terri-Lynn Mcgrath
    Copper Contributor
    Jul 13, 2018
    Awesome...thanks so much!
  • Terri-Lynn Mcgrath's avatar
    Terri-Lynn Mcgrath
    Copper Contributor
    Jul 13, 2018
    OK, that worked. So how do I add the bonus if they are full time? That is another criteria.
    • Haytham Amairah's avatar
      Haytham Amairah
      Silver Contributor
      Jul 13, 2018

      You can depend on this formula:

      =IF(B1>B2,IF(B3="PT",50,200),"")

       

      Please find the attached file.

      Regards

Resources