• 669K Members
• 9,936 Online
• 825K Conversations
SOLVED

Highlighted
New Contributor

# 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 conditions.

"200 kg"

"275 kg"

"400 kg"

Cell (C28) shows length of rail, which is determined by input data. I got this one

Cell (C30) shows "YES" if reinforcement is needed.

So, if choosing "200 kg" from the drop down menu and if C28 exceeds 3200 then C30 must show "YES" to reinforcement of rail.
If choosing "275 kg" from the drop down menu and if C28 exceeds 2750 then C30 must show "YES" to reinforcement of rail.
If choosing "400 kg" from the drop down menu and if C28 exceeds 2250 then C30 must show "YES" to reinforcement of rail.

My formula looks like this, but something is wrong.

=IF(B17="200 kg";IF(C28>3200;"YES";"NO"=IF(B17="275 kg";IF(C28>2750;"YES";"NO"=IF(B17="400 kg";IF(C28>2250;"YES";"NO"))))))

Best regards,

Martin Mayland

3 Replies
Highlighted
Solution

# Re: 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

Highlighted

# Re: Multiple IF's and drop down menu

Hi Nabil
Thank you so much, it works.
You are now officially my new Excel-hero

Martin
Highlighted