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.
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.
thank you so much!!! you're the best at explaining
Bros the reason im passing
Amazing, thank you
Bro great vid.
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
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.
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.
My if statement isn’t working
Can you copy the IF statement here