Google Sheets IF & IFS Functions - Formulas with If, Then, Else, Else If Statements
Вставка
- Опубліковано 23 сер 2024
- 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...
Website:
www.chicagocom...
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 👍😁
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.
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. ;-)
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.
AMAZING!!! This is the exact information I have been searching for for days and it's well explained!!
Excellent explonation, many examples, easy to understand. Thank you so much for this, we really apprieciate it.
This guy excels.
I'm adding my comment to the plethora of positive reviews, this was amazing!
thanks!
This video just sparked a thousand ideas!!! Thanks a million!
this video saved my ass from wasting anymore time on the functions. thank you so much, bro!
Great!
all I gotta say is thank you so much for making my life so much easier!!!
Works with non numeric values too! ie. ifs(D2=Adidas, 1, D2=Ralph Lauren, 2, ... TRUE, 0)
Thanks for the help!
WOW!! Best video ever! Thank you sooooooooooooooooooooooooooooooooo much.
Finally i made it work! Thank you!
I am studying for Google Educator certification. This was very helpful!
This helped me a lot. Well done LGS!
Very good explanation and patient narration too. Well done!
👍
Thanks for introducing IFS for me. Great tip.
Your videos are absolutely boss. A fantastic learning tool in Ramsgate United Kingdom.You have more than eaned my subscription. Thanks dude
Awesome, thank you!
@@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.
Exactly what I was looking ofr, thank you!!!!!!
:)
Thank you so much! This makes things so easy, i'm able to do things I never thought of doing.
great explanation. i feel confident on understanding if and ifs. thanks a lot.
👍
Oh my God, why did it never occur to me before to search UA-cam 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. 🙂
Very well explained! Thank you!
Amazing explanation, thanks a lot.
Glad you liked it
Thanks for making it clear
My exam is tomorrw and this has saved my grade
Really helped a lot.. so detailed explained.. I am happy to learn from you.
:)
You're awesome brother. love your videos!
Thanks 😊
Tutorial was very explicit.
Thank you so much! Super helpful!
Glad it helped!
Thanks a lot for this awesome video. This really helped a lot.
:)
Thank you. I was able to create a spreadsheet to track my Black Jack profits after watching your video.
Thank you so much this video helps me alot
Oh my God, it was so simple, goddammit! Thanks, you saved my brain.
That was SO helpful and exactly what the information I was needing. Thank you!
very helpful thank you!
Excellent! Great information to learn more. Thank You. :)
Thanks a lot. This was very helpful. Now I can finally build that time machine!
:)
Thank you
So helpful and easy to follow! Thanks for making this.
loved this video. looking forward to the rest of this playlist. Very helpful, can't wait to learn more. Thank you.
Great video, you're a good teacher!
شكرا 🌹
Really really useful and well explained. Thank you very much!
Awesome! Thank you!
Thanks So Much!☺
Thank you, very clear and helpful.
Me encanta la explicación y los ejercicios! Agradecida por estos vídeos 😃
Thank you for the help ! I was wondering how to do that ! Thank you very much !
thanks
Thanks Man! I was looking for this for a long time!
THANK YOU ! THIS IS GREAT
So thorough! Thank you!!!
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.😊
Great content man thank you so much for all these videos!!!
Super helpful! Thanks so much!!
Excellent tutorial, thank you for sharing!
Thank You, Very helpful video.
You are a life saver
Thank You!!
Bless you.
*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.
nice
Thank you so much for this is useful information about if, ifs functions.
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!
Awesome tutorial! But, I was wondering if we could delete a row if it was blank or had no data in it.
Excellent, thank you!
Ahhh that saved my life haha. was going mad with this problem
how dot make colour when the number is greater and when is smaller? that would be great
Conditional Formatting ua-cam.com/video/mgW0t5mu_As/v-deo.html
I used the formula: =IF(E10=TODAY(), "1") I wanted a field to have a number value ("1" in this formula) when the date of another field matches todays date, the E10 cell in this formula.
So, basically the formula says: When today's date = E10, place the text "1" into the field to which this formula is applied.
For my sheet, the "1" is a NUMBER field that gets added to another filed, that sums to add a dollar value to another field via another formula.
How to mark a student if they are weather excellent, good, ok or bad using their grades.
Example student "A" got 10 points wich means he is exellent. If he got 8 means he is good, and so on.
The table columns are telling the result of the students: Names , Grads, Excellent, Good, Ok, Bad.
The table rows are showing 100 of students' names. and grads.
The question is how or what function to use to let google sheet determine the students' behavior..
Hope you understand what I means. Thank you.
THANK YOU SOOOOOOO MUCH!!!!💯
Great Video. Thank you!
what if I want the true/false answer to be determined by subtracting two fields? for example Field A and B if B>A then I want it to say "gain" and subtract A from B If A>B I want it to say "loss" and subtract B from A would it look something like =if(B>A,"gain"A-B,"Loss"B-A) needless to say this didn';t work. What am I missing?
That really was helpful! Thanks!
What should I do if I only need to get the total sales of Adidas brand? What formula should I enter?
TNX BRO
really good video thanks!!!!!, helped me alot
Your tutorials are really Helpful..!
But i need this Datasheet ,
will you please provide me the link to practice with that
At 11:20 if you just use control shift down and then control d it will overwrite the column with new cell formula
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.
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.
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?
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.
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
for =if 'sales' and 'cogs' are > 10, for example, return 'yes' or 'no' for true or false respectively. how do i command it to do that?
Perfect!
Very helpful. Thank you!!
THANK YOU!!!! I DID IT!!! haha You saved the day!
Thank you so much sir
:)
man, your vid has the most ads appear that I ever watch. XD
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
Thank you!
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.?
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.
AWESOME
Have you a tutorial covering roundup numbers in Google sheets
Thank you for doing these videos. Do you have a bitcoin wallet that we can send donations to?
Did you save some for yourself
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?
gracias por el aporte... genial
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?
Hello. I was wondering how to create a formula that adds all the negative numbers in that column together?
SUMIFS ua-cam.com/video/AKs3aEtaEKw/v-deo.html