Forum Discussion

Mayland76's avatar
Mayland76
Copper Contributor
Aug 28, 2019
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...
Formulas and Functions
  • nabilmourad's avatar
    nabilmourad
    Aug 28, 2019

    Mayland76 

    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

nabilmourad's avatar
nabilmourad
MVP
Aug 28, 2019

Mayland76 

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

  • Mayland76's avatar
    Mayland76
    Copper Contributor
    Aug 28, 2019
    Hi Nabil
    Thank you so much, it works.
    You are now officially my new Excel-hero 🙂

    Martin

Resources