Forum Discussion
Terez2235
Mar 29, 2023Copper Contributor
Help For the life of me i cant get the IF & AND
AND, OR with IF combo Employee Name 2022 Sales 2023 Sales Bonus for 2022 (Yes/No)? $500 Gift card or No Gift card? ...
NikolinoDE
Mar 29, 2023Platinum Contributor
Yes, you can use IF function with AND and OR functions in Excel. Here is an example of how you can use them:
=IF(AND(B2>300000,C2>350000),"Yes","No")
This formula checks if the 2022 sales are greater than $300,000 and 2023 sales are greater than $350,000. If both conditions are true, it returns “Yes”, otherwise “No”.
Here is another example using OR function:
=IF(OR(B2>300000,C2>350000),"$500 Gift card","No Gift card")
This formula checks if either 2022 sales are greater than $300,000 or 2023 sales are greater than $350,000. If either condition is true, it returns “$500 Gift card”, otherwise “No Gift card”.
I hope this helps!
Terez2235
Mar 30, 2023Copper Contributor
Thank you I figured it out last night was driving me crazy its all new to me and at 60 I am trying to learn as much as possible Now i'm stuck on the IF & NOT lol