Using the New IFS Function in Excel
video description
Date: 2022-04-08
Related videos
Comments and reviews: 10
Awsse
I learned a great deal from you, thank you for the amazing videos you make. I have a question. Regarding the IF function, I want to make a survey table for customers of a specific city. All is going great except for one complicated detail. The survey table consists of 3 drop list that are in relation to each other which are (Region, District, Sector) respectively. I have 8 surviers each of them is responsible for a specific district that consists of 10+ sectors that belong to one of the 2 regions in my table, my question is can I use the IF function to minimise the choices of sectors to a specific survier only to his area of interest?
Note 1: Region, District & sectors are names not numbers
Note 2: Regions=2, District=12 Sectors=130
Thank you
reply
I learned a great deal from you, thank you for the amazing videos you make. I have a question. Regarding the IF function, I want to make a survey table for customers of a specific city. All is going great except for one complicated detail. The survey table consists of 3 drop list that are in relation to each other which are (Region, District, Sector) respectively. I have 8 surviers each of them is responsible for a specific district that consists of 10+ sectors that belong to one of the 2 regions in my table, my question is can I use the IF function to minimise the choices of sectors to a specific survier only to his area of interest?
Note 1: Region, District & sectors are names not numbers
Note 2: Regions=2, District=12 Sectors=130
Thank you
reply
Florin
I have tried the formula IFS today and put several conditions, as you did in this video, but my formula doesn't work, it recognises only the first and the last condition. I have checked and re-checked the formula, everything seems to be alright but still doesn't work. Would you please let me know if there are any common errors that this formula may give? Thank you very much!
reply
I have tried the formula IFS today and put several conditions, as you did in this video, but my formula doesn't work, it recognises only the first and the last condition. I have checked and re-checked the formula, everything seems to be alright but still doesn't work. Would you please let me know if there are any common errors that this formula may give? Thank you very much!
reply
Begur
Super presentation. But, I need to ask one question here. Suppose, I have dropdown list of all departments and also in dropdown one common dept for those who are reporting for this, can we not link it to the formula with the dropdown list. I mean Is there a short cut for formula creation with dropdown.
reply
Super presentation. But, I need to ask one question here. Suppose, I have dropdown list of all departments and also in dropdown one common dept for those who are reporting for this, can we not link it to the formula with the dropdown list. I mean Is there a short cut for formula creation with dropdown.
reply
Erica
Is there a way to use the IFS formula to determine the following if less than 2 hours you get paid $0, 2 hours but less than 6 hours you get paid $18, 6 hours but less than 12 hours you get paid $40, and 12 hours or more you get paid $55.
reply
Is there a way to use the IFS formula to determine the following if less than 2 hours you get paid $0, 2 hours but less than 6 hours you get paid $18, 6 hours but less than 12 hours you get paid $40, and 12 hours or more you get paid $55.
reply
Ivan
Instead of typing all the arguments on the formula bar, is it possible if I make an -another- Sheet first and then using the if arguments BASED ON THE SHEET i've make before to determine the value ?
-Sorry for bad english
reply
Instead of typing all the arguments on the formula bar, is it possible if I make an -another- Sheet first and then using the if arguments BASED ON THE SHEET i've make before to determine the value ?
-Sorry for bad english
reply
---
Is there anyway to force Excel to not interpret text as numerical values? In the second example, is there really no way to make Excel display a customized message if the corresponding value is obviously not a test score?
reply
Is there anyway to force Excel to not interpret text as numerical values? In the second example, is there really no way to make Excel display a customized message if the corresponding value is obviously not a test score?
reply
VISHAVDEEP
can we do this ? like in = if we assign a cell value. its
not working for me . i want to do this becasue my value of = , which i have to print is not a constant value it depend on other values
reply
can we do this ? like in = if we assign a cell value. its
not working for me . i want to do this becasue my value of = , which i have to print is not a constant value it depend on other values
reply
Geoffroy
Honestly, this is a bad IFS tutorial. Not that it's not well explained, but in all your examples I would have used a VLOOKUP or a XLOOKUP and it would have been much more efficient, flexible, etc.
reply
Honestly, this is a bad IFS tutorial. Not that it's not well explained, but in all your examples I would have used a VLOOKUP or a XLOOKUP and it would have been much more efficient, flexible, etc.
reply
Trucker
This will be valuable tomorrow. I'm grading a vocabulary quiz. But if a student writes a wrong answer, but it's almost correct, or spelled wrong, I can add partial points
reply
This will be valuable tomorrow. I'm grading a vocabulary quiz. But if a student writes a wrong answer, but it's almost correct, or spelled wrong, I can add partial points
reply
High
What if managers change? Is it possible to incorporate cell references to maintain integrity with manager changes? Ps I could have used this just today. Thanks!
reply
What if managers change? Is it possible to incorporate cell references to maintain integrity with manager changes? Ps I could have used this just today. Thanks!
reply
Add a review, comment
Other channel videos
