I have been fighting and fighting and fighting this for DAYS and lo and behold, found this, fluffed about and OMG IT WORKED!!!!!!!!!!!!!!!! Thank you!!!!!!!!!!!
What a great little blurb on IF Functions! IFS have been scratching my brain for the better half of today... Super grateful for your content - I've happily subscribed! :)
I am glad I found this video. It's been more than 1 week trying to figure out what functions should I use for multiple arguments. This video answered my questions. And my project is done. Thank you so much!
I am from Germany and my English is not really great and yet can I understand every word you say. It's because you speak so casually and professionally. I enjoy watching a few of your videos every night and I have a lot of fun watching your videos Best Danke 🙏🏽
You are absolutely stellar. Thank you so much for your videos. Just found your channel and it has helped SO much. Easily the most deserved sub I've ever given.
I'm SO glad I found you because you explain this so well. HOWEVER... this particular option seems not to apply to my situation: I have two columns; I want to return $30 if only one is checked (I use an "x" as a check), $60 if both are checked, but $0 if none is checked. I can't figure out, for the life of me, how the heck to do that. HAAAALP!!!
Hi! Can the IF function and the AND function be combined to check an table array of multiple values? Supposing I have name of the person in one array and the departments in another array,, how to use the IF and AND Function?
Hi sir, I'm trying to create a spreadsheet that will keep track of my studying and preparation for a big exam. I'm using space repetition to learn. So in my spreadsheet I have the date that I studied and I would like to add different values to this date depending on the ranking I give it. So for example, if I studied a Economics today but I don't feel like I know the material well I'll rank it a 3 (in a scale 1-10) and it will add 2 days from my last study session whereas a 10 will set it 21 days later. How can I do this? Thank you.
I have a question...I have a drop down menu of categories(>25) that all determine different percentage fees based on the selected category relative to the purchase price. Can I use an 'if' function to input a formula based on the category selected and the price of an item to yield a fee?
HELP! I am trying to create an if formula based on text. In one box I have the name of a ship. I would like it to return the capacity of that ship. I have multiple ships and each has a different capacity I know this could potentially be a very long formula but it would save me so much time I am willing to put in the work. Any help is appreciated!
For instance, the capacity of the Norwegian Bliss is 4004. The capacity of the Norwegian jewel is 2974. I would like the function to pop up the correct capacity based on the ship in an adjacent box.
Sir help me in defining (Excel format) IF "Duration less than 10 years" AND "Achievement 100%", then return 1000 or IF "Duration less than 10 years" AND "Achievement >=105%" then return 1500 OR IF "Duration more than 10 years" AND "Achievement >=100%" then return 2000
![[MV] A leap of faith...ความเชื่อใจครั้งสุดท้าย (From "Petrichor the series")](http://i.ytimg.com/vi/U1piZH2CNXA/mqdefault.jpg)
I have been fighting and fighting and fighting this for DAYS and lo and behold, found this, fluffed about and OMG IT WORKED!!!!!!!!!!!!!!!! Thank you!!!!!!!!!!!
Awesome ... glad you got it working, and thanks for your kind comment :)
What a great little blurb on IF Functions! IFS have been scratching my brain for the better half of today... Super grateful for your content - I've happily subscribed! :)
I am glad I found this video. It's been more than 1 week trying to figure out what functions should I use for multiple arguments. This video answered my questions. And my project is done. Thank you so much!
Thanks, good overview which is easy to understand. Paul
Great explanation thanks! Also congrats on completing the Souix Falls Marathon :-)
Thank you :)
Greatly appreciate the detailed explanations
Glad you liked it
Really Helpful....Simple and sweet explanations.
Glad you think so!
I am from Germany and my English is not really great and yet can I understand every word you say. It's because you speak so casually and professionally. I enjoy watching a few of your videos every night and I have a lot of fun watching your videos
Best Danke 🙏🏽
Thank you for your kind note, and I'm glad my videos are helpful :)
Thank you for the tutorial, sir.
You bet!
You are absolutely stellar. Thank you so much for your videos. Just found your channel and it has helped SO much. Easily the most deserved sub I've ever given.
Thank you for your kind note … and welcome :)
I'm SO glad I found you because you explain this so well. HOWEVER... this particular option seems not to apply to my situation: I have two columns; I want to return $30 if only one is checked (I use an "x" as a check), $60 if both are checked, but $0 if none is checked. I can't figure out, for the life of me, how the heck to do that. HAAAALP!!!
great video!!!!!!!!!!!!
Glad you enjoyed it! You're invited to get free Excel tips straight to your inbox, sign up here www.excel-university.com/subscribe/
Thanks alot
Most welcome
can you test this with an example on 3 or 4 columns please?
Hi! Can the IF function and the AND function be combined to check an table array of multiple values?
Supposing I have name of the person in one array and the departments in another array,, how to use the IF and AND Function?
Hi sir, I'm trying to create a spreadsheet that will keep track of my studying and preparation for a big exam. I'm using space repetition to learn. So in my spreadsheet I have the date that I studied and I would like to add different values to this date depending on the ranking I give it. So for example, if I studied a Economics today but I don't feel like I know the material well I'll rank it a 3 (in a scale 1-10) and it will add 2 days from my last study session whereas a 10 will set it 21 days later. How can I do this? Thank you.
I have a question...I have a drop down menu of categories(>25) that all determine different percentage fees based on the selected category relative to the purchase price. Can I use an 'if' function to input a formula based on the category selected and the price of an item to yield a fee?
I hope this video helps with your question: th-cam.com/video/rD7x4pTzCYs/w-d-xo.html
Thanks
Jeff
HELP! I am trying to create an if formula based on text. In one box I have the name of a ship. I would like it to return the capacity of that ship. I have multiple ships and each has a different capacity I know this could potentially be a very long formula but it would save me so much time I am willing to put in the work. Any help is appreciated!
For instance, the capacity of the Norwegian Bliss is 4004. The capacity of the Norwegian jewel is 2974. I would like the function to pop up the correct capacity based on the ship in an adjacent box.
Sir help me in defining (Excel format)
IF "Duration less than 10 years" AND "Achievement 100%", then return 1000 or IF "Duration less than 10 years" AND "Achievement >=105%" then return 1500 OR IF "Duration more than 10 years" AND "Achievement >=100%" then return 2000
Text is displayed,pl edit and upload