MS Excel | AND, OR and NOT operators

[@LoL-jz9kv]

Bros the reason im passing

[@EmilyParfenoff]

thank you so much!!! you're the best at explaining

[@yasminkhalifa8709]

Amazing, thank you

[@Jessie_Amani]

Sir on the Supplementary column I'm receiving incorrect results with the correct function. All of them say no even for the a average pass

[@kamaldehra8367]

Bro great vid.

[@carlheinzl2172]

At 3:40 in the video, you say, "Where would you use this? You would use it in an IF statement." The IF is redundant. You write the equation (Around 4:00) as =IF( AND(B11>=50,C11>=50), however that can be simplified by just saying =AND(B11>=50,C11>=50) . The AND will return true or false depending on the status of all of the parts inside the and statement. I see no reason why the superfluous "IF" would be added in front.

[@MrLongITandCAT]

Yes, the video is just demonstrating how the AND and OR works. You don't need the IF statement if display true and false but I wanted to show an example in an If statement in the event you wanted to display other options.

[@EyesonITNA]

My if statement isn’t working

[@MrLongITandCAT]

Can you copy the IF statement here