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

[Terez2235]

AND, OR with IF combo
Employee Name	2022 Sales	2023 Sales	Bonus for 2022 (Yes/No)?	$500 Gift card or No Gift card?
Cary Grant	$ 613,737.00	$ 385,584.00
Agnes Morehead	$ 358,549.00	$ 713,596.00
Jean Arthur	$ 229,897.00	$ 476,917.00
Claudette Colbert	$ 477,597.00	$ 492,161.00
Mary Astor	$ 241,519.00	$ 763,014.00
Erol Flynn	$ 313,668.00	$ 508,799.00
Sonam Kapoor	$ 327,610.00	$ 483,833.00				2022 Sales goal	$                                                                                                                                                                    300,000.00
Ralph Richardson	$ 321,554.00	$ 275,158.00				2023 Sales goal	$                                                                                                                                                                    350,000.00
Barbara Stanwyk	$ 344,992.00	$ 606,164.00
Bob McSimmons	$ 236,919.00	$ 221,405.00				Information for the practice
Deborah Kerr	$ 448,222.00	$ 355,115.00				AND Function	Column B is greater or equal to the 2022 Sales goal AND column C is greater or equal to the 2023 Sales goal	True Message	Yes	False Message	No
Juhi Chawala	$ 301,789.00	$ 327,533.00				OR Function	Column B is greater or equal to the 2022 Sales goal OR column C is greater or equal to the 2023 Sales goal	True Message	$500 Gift card	False Message	No Gift card
Mary Nash	$ 247,266.00	$ 675,008.00
Ginger Rogers	$ 452,636.00	$ 269,868.00
Howard Hawks	$ 434,156.00	$ 525,686.00
Fred Astaire	$ 186,735.00	$ 318,519.00
Edward Horton	$ 245,215.00	$ 376,783.00
Don Costello	$ 396,580.00	$ 182,512.00
Robert Wise	$ 552,444.00	$ 481,071.00
Sonakshi Sinha	$ 435,242.00	$ 224,188.00
Elsa Bannister	$ 250,602.00	$ 826,083.00
Thomas Mitchell	$ 194,173.00	$ 584,585.00
Ryan O'Neal	$ 199,847.00	$ 229,704.00
Rhett Butler	$ 171,505.00	$ 202,088.00
Irene Dunne	$ 112,506.00	$ 172,677.00
Vivien Leigh	$ 275,820.00	$ 350,684.00
Michael O'Hara	$ 366,855.00	$ 410,645.00
Shah Khan	$ 484,264.00	$ 228,422.00
Scarlett O'Hara	$ 316,910.00	$ 544,300.00
Rani Mukerji	$ 219,569.00	$ 262,799.00
Hrithik Roshan	$ 114,049.00	$ 814,577.00
Mary Austin	$ 136,153.00	$ 440,022.00
Joseph Cotton	$ 444,661.00	$ 424,881.00
Grace Kelly	$ 324,957.00	$ 736,398.00
Orson Welles	$ 449,250.00	$ 880,121.00
Claude Rains	$ 297,131.00	$ 641,569.00
Mariam DeSouza	$ 331,008.00	$ 501,190.00
Montgomery Clift	$ 467,414.00	$ 320,613.00
Joel McCrea	$ 410,212.00	$ 570,588.00
Gary Cooper	$ 172,094.00	$ 260,607.00
Howard Hughes	$ 344,040.00	$ 851,913.00
Virginia Weidler	$ 210,059.00	$ 683,804.00
William Holden	$ 459,026.00	$ 862,645.00
Veer Singh	$ 472,580.00	$ 822,522.00
Robert Montgomery	$ 358,702.00	$ 621,544.00
Shahid Kapoor	$ 478,890.00	$ 305,078.00
Greta Garbo	$ 347,824.00	$ 684,738.00
Shilpa Shetty	$ 281,140.00	$ 749,607.00
Sal Mineo	$ 342,918.00	$ 636,405.00
Rudy Vallee	$ 235,212.00	$ 868,914.00
George Cukor	$ 501,071.00	$ 199,542.00
Rita Hayworth	$ 307,074.00	$ 599,529.00
Samantha Bergston	$ 351,691.00	$ 185,114.00
James Stewart	$ 540,000.00	$ 173,068.00
Peter Lawford	$ 244,477.00	$ 415,418.00
Gloria Swanson	$ 490,372.00	$ 642,224.00
Leo McCary	$ 453,624.00	$ 417,977.00
Walter Connolly	$ 143,004.00	$ 472,983.00
Gene Kelly	$ 133,429.00	$ 166,207.00
John Halliday	$ 242,087.00	$ 403,215.00
Brian Johnston	$ 214,304.00	$ 509,193.00
Erich Stroheim	$ 177,761.00	$ 882,035.00
Elizabeth Taylor	$ 508,477.00	$ 834,402.00
Ruth Hussey	$ 243,848.00	$ 294,065.00
Clark Gable	$ 218,320.00	$ 513,855.00
Katharine Hepburn	$ 419,564.00	$ 754,992.00
Dorothy Comingore	$ 366,770.00	$ 281,801.00
Leslie Caron	$ 515,253.00	$ 599,688.00
Shri Devi	$ 395,429.00	$ 803,255.00
Gregg Toland	$ 377,067.00	$ 614,239.00

[#2]

@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!

[#3]

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