Forum Discussion
Multiple IF's and drop down menu
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
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 so much, it works.
You are now officially my new Excel-hero 🙂
Martin