SWITCH Function (Multiple IF conditions, IFS function) - Google Sheets - similar in Excel
HTML-код
- Опубликовано: 31 июл 2024
- Learn how to use SWITCH function in Google Sheets or Excel to create multiple If statements. Understand the difference between SWITCH & IFS functions.
Function covered in this tutorial: SWITCH, IFS, DGET, YEAR, MONTH
#googlesheets #excel
Your videos are amazing, that have taken my work load from 30 hours a week to 4. Thanks so much.
thank you so much for sharing this information, love you bro
Great video!!! Thnx!!
great explanation. thanks
Thank you for your teaching
I can't believe I didn't know about adding line breaks in formulas! Thank you!!! It would be super awesome if we could also add comments!
could you go between years with switch? That would eliminate all the other dgets. I like the way you showed how to make it easier to read. So many times I just missed one area because it is all together. You give me so many good ideas that make my work easier. But then I have to go back and change everything to make my sheets work better.
Sorry to hassle you, I have a small problem I have been using multiple 'If' statements to cover multiple conditions in which a price can be adjusted, but since it pulls the first true one and does that it is not applying a 2nd + calculation if the requirement is met for multiple conditions. what do I do if I wanted it to express multiple true 'If' statements so that it changes the price multiple times to match all of the conditions I have expressed elsewhere in the sheet? I know I can't use the If function for that, but for now I've had to make a line of text for every single combination of price adjustment conditions, and to code them all, and do something like "=If(A2="CodeOne",B2+D1) where B2 would be that codes added conditions, and D1 would be the price that needed changed. I have so many conditions that this is unrealistic
🙏🏻
Hey there, I have a formula that call texts from a cell if the value within a specific other cell is 3.5 or higher. However, it will always call the text from within the first cell it meets in the sequence that has this 3.5 and over value and will stop there. I would like my formula to keep appending text from other cells with a 3.5 value that come after. Here's my formula : =CONCATENER("(+) ";C7;IFS(H7>=3,5;P7;I7>=3,5;P8;J7>=3,5;P9;K7>=3,5;P10))........ Can you help me? I am a newbie with google sheet formula... I may have to use arrays or something like that but I am not sure.
7:00
Youcan use indirect function
I also thought of that but I remembered he already has indirect covered in another video. This video is an example to teach switch. ;-)
Also keep in mind that indirect will break if you change the name of the worksheet and switch will not. I have the same problem solved with INDIRECT here ruclips.net/video/Vuh7lh2mhQk/видео.html
but if we want to have like before July 2021 = Q1, before October 2021 = Q2
Hello. I have a question. Can I use the IFS with the Filter function on Google sheet? I tried it but it didn't work. Also I tried it the same functions on the MS Excel and It worked.
Yes, you can.
@@ExcelGoogleSheets Hmmm Can you please check it? Sorry to bother you. :(
Error : =IFS(I1=1, FILTER(B:B,C:C="a"),I1=2, FILTER(B:B,C:C="B"))
Error : =FILTER(B:B,IFS(I1=1,C:C="a",I1=2,C:C="b"))
Working : =Filter(B:B,IF(I1=1,C:C="a",C:C="b"))
Working : =IF(I1=1,Filter(B:B,C:C="a"),Filter(B:B,C:C="b"))
So based on this I assume this works?
=IF(I1=1, FILTER(B:B,C:C="a"),IF(I1=2, FILTER(B:B,C:C="B"),""))
@@ExcelGoogleSheets Yes. It works!
Then it looks like IFS doesn't work with filter after all.
In tablet is different
Functions should be the same everywhere.