Forum Discussion
Solved
Multiple IF's and drop down menu
Hello I am a novice in Excel and have an issue that I can't seem to solve myself - I am lost. Case: Drop down menu with 3 products cell (B17). Each of these products have different condition...
Hi Martin
I created a function for you that meets your combinations for the 3 weights.
Note: the numbers in cell C28 SHOULD NOT have Kg in the same cell. Otherwise, you cannot use them in calculations. What you see in my attached file is custom formatting stored in memory.
The function created in Cell C30 is:
=IF(OR(AND(C17=200,C28>3200),AND(C17=275,C28>2750),AND(C17=400,C28>2250)),"YES","NO")Please look at the attached file.
Hope that helps
Nabil Mourad
Thank you for your nice words. I'm glad I could help.
you can join over 20K Excel lovers learning Excel topics from me on my YouTube Channel
YouTube.com/OfficeInstructor
Best of Luck
Nabil Mourad