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
www.google.com/sheets/about/
Website:
www.chicagocomputerclasses.com/

[@lb4082]

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 👍😁

[@sandracinquegrana7806]

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

[@johngddr5288]

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

[@keah4063]

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. ;-)

[@judylanum7719]

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.

[@cathyoyama9938]

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

[@marielaci]

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

[@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.

[@Biketherapy113]

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

[@nomadicallydigital5480]

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

[@lisamartens680]

So helpful and easy to follow! Thanks for making this.

[@Lookin4Reasons2Laugh]

So thorough! Thank you!!!

[@assssssassssssssas]

Thanks Man! I was looking for this for a long time!

[@sct.anonymous]

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

[@lethalbizzle1187]

Great content man thank you so much for all these videos!!!

[@christopherc.taylor339]

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

[@MortenCopenhagen]

Thanks for introducing IFS for me. Great tip.

[@EggBram]

Excellent tutorial, thank you for sharing!

[@ms.janetiraola8939]

Very well explained! Thank you!

[@jonathanwhitehead9253]

Thank you. I was able to create a spreadsheet to track my Black Jack profits after watching your video.

[@joshfriedrich7363]

Great video, you're a good teacher!

[@tanjakanis2842]

Thank you for the help ! I was wondering how to do that ! Thank you very much !

[@kibsaimhernandez2690]

You're awesome brother. love your videos!

[@willwright3358]

That really was helpful! Thanks!

[@lynneb2262]

Thank you, very clear and helpful.

[@esnvlogs4489]

Great Video. Thank you!

[@RajKumar-ku4qz]

Thank you so much for this is useful information about if, ifs functions.

[@joannequach3712]

Thanks 😊 Tutorial was very explicit.

[@JeffRemasPhotography]

Very helpful. Thank you!!

[@KYjchan]

Super helpful! Thanks so much!!

[@martinmyggestik292]

Thanks a lot. This was very helpful. Now I can finally build that time machine!

[@ExcelGoogleSheets]

:)

[@genesisarellano2830]

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

[@JoeDelaney64]

Thank You, Very helpful video.

[@maykelfigueroa5158]

Hi, thank you for sharing your knowledge. Question: I practice on my computer the if function but for some reason, it can not multiply or divides inside the if function. Do you ha an idea what it could be? or anyone can tell me what it could be. Thank you in advance.

[@R4V3-0N]

This helped me a lot. Well done LGS!

[@NehasBakery]

Could you help me embed a editable Google sheet in blogger..

[@kids3dacademy495]

WOW!! Best video ever! Thank you sooooooooooooooooooooooooooooooooo much.

[@aurelian4034]

Finally i made it work! Thank you!

[@jspyce]

Excellent, thank you!

[@argonaut119]

Nice Vid! Excellent instruction. One question: Can you make that sample Logical Test worksheet available? It makes it easier for the starting Sheets student to have a sample table available. Good job!

[@sarahwheeler2078]

THANK YOU!!!! I DID IT!!! haha You saved the day!

[@tingtingwells2777]

Really really useful and well explained. Thank you very much!

[@ExcelGoogleSheets]

Awesome! Thank you!

[@outthemoney1067]

Excellent! Great information to learn more. Thank You. :)

[@jeremydumanski7584]

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

[@ExcelGoogleSheets]

thanks!

[@talic-os5899]

Oh my God, it was so simple, goddammit! Thanks, you saved my brain.

[@AbhishekKumar-nm8ei]

Thanks for this videos it's really helpful for me. have one question related with IFS function, How many condition we can apply in single IFS function.

[@samueloliver5598]

really good video thanks!!!!!, helped me alot

[@HoneyLaBronx]

Oh my God, why did it never occur to me before to search KZbin 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. 🙂

[@TReaL007]

Would you be able to help? I want sheets to recognize Jon in column A, take column J dollar amount, and multiply . 75 into Column O. Would you be able to put a formula for that? Thanks

[@soulevpeupl3030]

THANK YOU ! THIS IS GREAT

[@anthonyfulton3994]

Can I use multiple conditions to auto-populate a cell on another page? For example, If I have a list of transactions that have dropdown menus to categorize the expenses on the appropriate tab, can I give a date range and category selection be a qualifiers to populate the appropriate sheet?

[@Nubian_Traveller]

Thanks for making it clear

[@davidsookharry8555]

your tutorials are great! how would you get a google form to give a message "youve already applied "when submitted. the criteria to be checked first name, surname, middle name, and 3 different ID 's like national id ,drivers permit no. and passport no.?

[@shubham96agarwal]

Very good explanation and patient narration too. Well done!

[@ExcelGoogleSheets]

👍

[@OscarWrightZenTANGO]

Can you help ? I have created an expense income sheet. When an expense is made by credit care, I would like to the sum to subtract from the row which contains the running credit card balance as well as subtract from the row which contains the overall balance.

[@maks327]

very helpful thank you!

[@vvdd903]

great explanation. i feel confident on understanding if and ifs. thanks a lot.

[@ExcelGoogleSheets]

👍

[@dmanakell]

You are a life saver

[@donaldjones8920]

Exactly what I was looking ofr, thank you!!!!!!

[@ExcelGoogleSheets]

:)

[@pmarkpmark]

Can something like the IF function be done when there is a data table that I'm comparing it to. Like, if you had a tab where it only said The Brand Name, and the associated Product Category. Could the IF function (or something else) be used on another tab so that when you enter Adidas, Low-End Product would appear to a cell nearby? I'm trying to make a table pull fixed data on another tab.

[@jawadmurtaza8908]

Thank you so much this video helps me alot

[@edgarelly]

Okay so say i'm looking at dimensions and want to use the dimensions to get a value from another sheet. for example. If side a is less than or equal to 10 inches and side b is less than or equal to 10 inches, and side c is less than or equal to 5 inches then cell B3, If side is from 10 to 15in, side b is 10-15, and side c is 5-10 then cell c3 etc... how would i go about building that?

[@pranavsathi6709]

Awesome tutorial! But, I was wondering if we could delete a row if it was blank or had no data in it.

[@lmwpictures7910]

THANK YOU SOOOOOOO MUCH!!!!💯

[@nicholemaggio1881]

Thank you so much! Super helpful!

[@ExcelGoogleSheets]

Glad it helped!

[@nourdarwish8095]

Amazing explanation, thanks a lot.

[@ExcelGoogleSheets]

Glad you liked it

[@Burdenedwarrior]

This guy excels.

[@ArtWithRosie1]

Thanks So Much!☺

[@nickieoakwood6926]

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

[@ExcelGoogleSheets]

Awesome, thank you!

[@nickieoakwood6926]

@@ExcelGoogleSheets Your local (UK) pest again. Am at the stage of got both sales form and macro sales button. How do I get the button to call up the sales form macro? Am only this far down to you so you sort of owe me lol. Seriously when both form and menu item appeared it was like Tom Hanks Castaway FIRE. ISOLATED SO SOLO VICTORY HAHA. Many thanks! Do I somehow tweak this: function onOpen(){ initMenu(); } perhaps: function onClick(){ showuserForm(); } I just don't want to break it now it is 90% there.

[@conquestgaming5445]

So I have 1 Cell on One Sheet I want to Show 2 cells from another sheet if they're not blank.However if one is not blank and the other is blank I want it to show the None Blank Cell and if the both blank i want it to Show up as Blank. How would I do this and What would the Formula Be to do it? Im having some trouble on this so if you can help it would be much appreciated!

[@briantooley8459]

Perfect!

[@aleksandrabartosik6317]

So if I have to create formula for seniority levels like 0-.1= junior etc so how I should formulate this?

[@arpitdoshi]

Really helped a lot.. so detailed explained.. I am happy to learn from you.

[@ExcelGoogleSheets]

:)

[@dfgaccounting7856]

Loved the video supper helpful! I have a question is it possible for a formula that says "if column B from sheet 1 matches Column A on sheet 5, then column B from sheet 5 would copy and auto-populate in Column A of sheet 1"? or something similar haha, do you ever take requests for videos? I would love that one haha

[@jfarm7820]

You are so perfectly clear in how these functions work, and in describing as many possible scenarios where it coul dbe used and where we could encounter bumps. So appreciated - awesome video. BUT!!! QUESTION!!! I can not seem to add up this new "ifs" column. After successfully entering an ifs formula that gives the cells a numerical value, I now want to add up all these values. I've tried the basic "sum(a1:a25)", but it keeps giving a value of zero. I also am struggling to find a google search relevant to this exact issue, as I keep getting results for "sumifs" and "countifs", and that's not what I'm doing. Any ideas?

[@sct.anonymous]

it is likely because the values in the "ifs" column are not actually numbers. The IF function can return either a value or a text string, depending on what you specify as the value_if_true or value_if_false arguments. If you have any text strings in your "ifs" column, the SUM function will not be able to add them up. To check if this is the case, you can try using the VALUE function to convert any text strings to numbers. For example, if your "ifs" values are in cells A1 to A25, you can try using the following formula: =SUM(VALUE(A1:A25)) This will attempt to convert any text strings in the "ifs" column to numbers, which can then be added up using the SUM function. If this still doesn't work, it's possible that there may be an error in your IF formula or that there may be hidden characters or spaces in the "ifs" column that are causing issues. In this case, you may want to try copying and pasting the values into a new column or using the TRIM function to remove any extra spaces.

[@mr.girardo8926]

Thank You!!

[@kenneyshepard4511]

Could you do if statements for Google scripts? It's a little bit different when you throw Javascript in the mix and I'm have a tough time.

[@cassgryphon]

Thank you!

[@Thenarayanaclips]

Thanks a lot for this awesome video. This really helped a lot.

[@ExcelGoogleSheets]

:)

[@TruthBeliever1God]

Hello, thank you for this video. I can't seem to find instructions for my specific needs. I am trying to assign a point or value system to text. So if the text is "APPR" each of that text name would = 1 point, and then I need to get totals for each text value. Please advise.

[@adamkern3976]

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

[@mariomendez6404]

hi thanks for your knowledge,how can i contact you for help on a specific problem?

[@PLORA73]

Thank you.

[@dharevans9827]

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

[@ExcelGoogleSheets]

Great!

[@franponcio5621]

gracias por el aporte... genial

[@jamesgarvey2090]

Can you use this function to make change from a sale? Say someone bought a $0.13 item and paid $1.00, change would be $0.83 but the function would return the coins, ideally 3x0.25, 1x0.05, 3x0.01 or 3x.025, 0x0.10, 1x0.05, 3x0.01 To take it a step further could you have a table of existing change in a drawer and divvy up the coins based on the quantity? Something like you had no 0.05 coins but had 47x0.01 coins so you would end up giving 3x0.25, 8x0.01.

[@RFX001]

Is there a way I can a number bold or change the in a cell if the value is less/more than or equal to another cell?

[@lokedistor5860]

Hello is it possible to add a cap margin value indicator in a formula??

[@misssomod194]

شكرا 🌹

[@eriadenmusic]

Thank you

[@jessel.bennett2409]

Thanks for the video! Question, I'm using a google form to populate the sheet, and I have script to insert the new entry to the top each time, I have a row of checkboxes that will mark rows complete and change the fill color of the row. Problem is each new entry will not have them because of the new row adding to the top of the sheet. How can I correct this?

[@ExcelGoogleSheets]

Have you tried apllying conditional formatting to the whole column, instead of using a regular range.

[@Vagkit1]

Bless you.

[@davidbrady9611]

Have you a tutorial covering roundup numbers in Google sheets

[@Eyhan-ir3uj]

I appreciate your teachings! Thanks for sharing your amazing talent in manipulating data in google sheets. Though i have a quick question if it’s okay. If what’s the best formula to use if your looking to count the accuracy averages. Like if you want to know if what’s the average of those who answered same with mine and those who have different. Like i if i put yes, id like to check the average of those you answered yes and those who answered no.😊

[@tashfiqshanto7300]

Your tutorials are really Helpful..! But i need this Datasheet , will you please provide me the link to practice with that

[@florenciagirman2357]

IS there a way to create an IF statement to move information from one column to another, so if there's something in column A then move it to Column AB

[@markkaluzka2323]

I am trying to have an ifs function check 2 values. I tried to use the and function and it worked for the first logical test but it kept making me end with a ,0 at the end if the first logical test. Not sure if i messed up the phrases =ifs(and(e17="yes",d17>=1000),d17*0.2,0,and(e17="yes",d17>=500,d17*0.1,0). If you could hell point out my error that would be much appreciated!!

[@MishraArts]

Thank you so much sir

[@ExcelGoogleSheets]

:)

[@kamenkojic]

*Your videos are really good.* All the best. Please, could you help me to solve the situation so that after entering the given function in its entirety, we turn it off so that there would be no later change. Let's say that occurs with the price of a product, when I change it, it creates chaos in the previous state. Thanks in advance for the reply.

[@algalgaq]

If possible to make push notifications if a google sheet that it dynamic feeds it self whit external data using conditionals operators. I mean can you run scripts for example . Example I got number in red then I send scrip to interact whit other app for example? Or example I got a sensor value true or false if is true then exec (script) made to set off alarm for example or start recording then can access from my Google sheet link to see the record