MS Excel | AND, OR and NOT operators

  Рет қаралды 32,218

Mr Long Education - IT & CAT

Mr Long Education - IT & CAT

Күн бұрын

Пікірлер
@LoL-jz9kv
@LoL-jz9kv 4 ай бұрын
Bros the reason im passing
@EmilyParfenoff
@EmilyParfenoff 3 ай бұрын
thank you so much!!! you're the best at explaining
@yasminkhalifa8709
@yasminkhalifa8709 2 жыл бұрын
Amazing, thank you
@Jessie_Amani
@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
@kamaldehra8367 3 жыл бұрын
Bro great vid.
@carlheinzl2172
@carlheinzl2172 9 ай бұрын
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
@MrLongITandCAT 8 ай бұрын
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
@EyesonITNA Жыл бұрын
My if statement isn’t working
@MrLongITandCAT
@MrLongITandCAT Жыл бұрын
Can you copy the IF statement here
MS Excel | Lookup Functions
14:04
Mr Long Education - IT & CAT
Рет қаралды 71 М.
Master the IF Formula in Excel (Beginner to Pro)
11:16
Kenji Explains
Рет қаралды 564 М.
It’s all not real
00:15
V.A. show / Магика
Рет қаралды 20 МЛН
Cat mode and a glass of water #family #humor #fun
00:22
Kotiki_Z
Рет қаралды 42 МЛН
MS Excel | Wildcards
8:02
Mr Long Education - IT & CAT
Рет қаралды 19 М.
MS Excel | IF Function
13:47
Mr Long Education - IT & CAT
Рет қаралды 51 М.
Say Goodbye to IF Statements in Excel with SWITCH
7:45
Teacher's Tech
Рет қаралды 594 М.
Excel Logical Functions - IF, AND, OR
8:05
Yoda Learning Academy
Рет қаралды 221 М.
MS Excel | Evaluate Formulas
7:02
Mr Long Education - IT & CAT
Рет қаралды 15 М.
Excel Functions: AND(), OR() within IF()
7:30
Six Minutes. Smarter.
Рет қаралды 574 М.
Excel OFFSET Function - including Common MISTAKES to Avoid!
13:52
MyOnlineTrainingHub
Рет қаралды 51 М.
Using Excel's XLOOKUP Function
11:16
Technology for Teachers and Students
Рет қаралды 106 М.
Highlight Active Row & Column in Excel (7 Levels)
22:56
Victor Chan
Рет қаралды 77 М.