Help For the life of me i cant get the IF & AND

Terez2235 

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!