Google Sheets IF & IFS Functions - Formulas with If, Then, Else, Else If Statements

Video tutorial about Logical Test/Expression, IF function & IFS function in Google Sheets.

In this tutorial we'll cover how to use formulas with If, Then, Else, Else If statements using IF & IFS functions in Google Sheets.

Google Sheets

Website:

[lb]

I used to try to find -and watch- the video that applied to my sheet, before I started working on it.... Now I just watch ANY one of this guy's vids. Its a great help to my process, to just watch him methodically "logic"things out. It's been a huge help 👍😁

[judylanum]

Thank you, thank you, thank you. I have scoured the internet for days looking for an explanation of "if then else" statements and / or the understanding of "ifs" statements. The help documents are worthless. I have subscribed and feel I will be watching your videos often. Short, clear, and on point. Please keep up the good work.

[sandracinquegrana]

AMAZING!!! This is the exact information I have been searching for for days and it's well explained!!

[keah]

I'm a trainer and I commend you for your EXCELLENT training! You've explained this CLEARLY and illustrated it well. Thank you! I've subscribed. ;-)

[deifiedtitan]

Thanks for this. Google's own help documentation with the square brackets surrounding additional if targets was what was causing mistakes, your vid showed I didn't need them and it worked.

[sct.anonymous]

Excellent explonation, many examples, easy to understand. Thank you so much for this, we really apprieciate it.

[jeremydumanski]

I'm adding my comment to the plethora of positive reviews, this was amazing!

[HoneyLaBronx]

Oh my God, why did it never occur to me before to search YouTube for this??? I am OBSESSED with Google Sheets lately and using it for everything. And my hunger to know more is growing as my data needs expand. What a treasure trove! Thank you! By the way, I adore your accent. Are you Dutch? I dated a guy from the Netherlands and it sounds like the same accent. 🙂

[christopherc.taylor]

This video just sparked a thousand ideas!!! Thanks a million!

[johngddr]

Thank you so much! This makes things so easy, i'm able to do things I never thought of doing.

[genesisarellano]

all I gotta say is thank you so much for making my life so much easier!!! <3

[nomadicallydigital]

I am studying for Google Educator certification. This was very helpful!

[dharevans]

this video saved my ass from wasting anymore time on the functions. thank you so much, bro!

[marielaci]

Me encanta la explicación y los ejercicios! Agradecida por estos vídeos 😃

[kidsdacademy]

WOW!! Best video ever! Thank you much.

[cathyoyama]

That was SO helpful and exactly what the information I was needing. Thank you!

[MortenCopenhagen]

Thanks for introducing IFS for me. Great tip.

[adamkern]

Works with non numeric values too! ie. ifs(D2=Adidas, 1, D2=Ralph Lauren, 2, ... TRUE, 0)
Thanks for the help!

[nickieoakwood]

Your videos are absolutely boss. A fantastic learning tool in Ramsgate United Kingdom.You have more than eaned my subscription. Thanks dude

[Biketherapy]

loved this video. looking forward to the rest of this playlist. Very helpful, can't wait to learn more. Thank you.