MS Excel | IF Function

preview_player
Показать описание
This video covers the IF function that is used in the spreadsheet software Microsoft Excel. This function is used when you want to display two different options or use two different formulas based on a condition.

#MrLongEducation #Excel #IFFunction
Рекомендации по теме
Комментарии
Автор

Thank you, sir! I'm writing practical tomorrow and this is really helping!

arwinweenink
Автор

All my life I've been doing it the long way, but I've changed! I'm going it the Mr long way, it's less time consuming😌

Dxviddddd
Автор

Thank you very helpful content for my test Tommorow 😃

BokangSin
Автор

May Christ bless you abundantly Mr Long. Thank you

YHWHs_D
Автор

I have a big test tomorrow and I’m pretty sure I’m gonna nail this function😊you make it so easy to understand

ntokozomngomezulu
Автор

You dont understand how much you help, thank you Mr Long way🙌😌

gaigehunt
Автор

Hey Mr Long, how do we do it if in the second part of the formula (if false) isn't supposed to change the value?

NobuhleMahlangu-sv
Автор

Hi can you make a video on how we would address a 3 way IF statement.

brysonrampersad
Автор

Hey Mr Long

I tried the =SUMIF(C4:C23;"F";E4:E23) formula for the "total amount raised by females" and it gave me 0 and same goes for the =SUMIF formula for "total amount raised by those with 6 or more points"

Why does it give me 0 as an answer?

Ogone