Aug 28 2019 12:43 AM
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"))))))
I really appreciate your help.
Best regards,
Martin Mayland
Aug 28 2019 06:08 AM - edited Aug 28 2019 06:13 AM
SolutionHi 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
Aug 28 2019 07:07 AM
Aug 28 2019 08:31 AM
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
Aug 28 2019 06:08 AM - edited Aug 28 2019 06:13 AM
SolutionHi 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