Тёмный

MS Excel | AND, OR and NOT operators 

Mr Long Education - IT & CAT
Подписаться 52 тыс.
Просмотров 29 тыс.
50% 1

Опубликовано:

 

20 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 9   
@EmilyParfenoff
@EmilyParfenoff Месяц назад
thank you so much!!! you're the best at explaining
@LoL-jz9kv
@LoL-jz9kv 2 месяца назад
Bros the reason im passing
@yasminkhalifa8709
@yasminkhalifa8709 2 года назад
Amazing, thank you
@kamaldehra8367
@kamaldehra8367 2 года назад
Bro great vid.
@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
@carlheinzl2172
@carlheinzl2172 6 месяцев назад
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 6 месяцев назад
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 | Evaluate Formulas
7:02
Просмотров 13 тыс.
MS Excel | Lookup Functions
14:04
Просмотров 65 тыс.
10 CHALLENGE ⚽️ CELINE vs MICHIEL vs BRAM
0:59
Просмотров 2,9 млн
MS Excel | Text Functions
19:28
Просмотров 47 тыс.
Excel Logical Functions - IF, AND, OR
8:05
Просмотров 192 тыс.
MS Excel | Nested IF Statements
9:07
Просмотров 78 тыс.
Say Goodbye to IF Statements in Excel with SWITCH
7:45
Master the IF Formula in Excel (Beginner to Pro)
11:16
Просмотров 495 тыс.
MS Excel | Wildcards
8:02
Просмотров 17 тыс.
Let's Concatenate!
7:34
Просмотров 4,8 тыс.
MS Excel | Types of Errors & isError Function
9:49
Просмотров 12 тыс.
Excel for Beginners - The Complete Course
54:55
Просмотров 7 млн