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!!!!!!!!!!!
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 🙏🏽
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!
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! :)
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.
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?
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
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.
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?
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 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 :)
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 :)
great video!!!!!!!!!!!!
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!
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! :)
Thanks, good overview which is easy to understand. Paul
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 :)
Greatly appreciate the detailed explanations
Glad you liked it
Really Helpful....Simple and sweet explanations.
Glad you think so!
Thank you for the tutorial, sir.
You bet!
Great explanation thanks! Also congrats on completing the Souix Falls Marathon :-)
Thank you :)
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?
can you test this with an example on 3 or 4 columns please?
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
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.
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: ua-cam.com/video/rD7x4pTzCYs/v-deo.html
Thanks
Jeff
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.
Text is displayed,pl edit and upload