Forum Discussion
Excel Formula, combining two IF statements
These two formulas are conflicting in logic if to combine them. Let assume B3 is more than 50. With that if E3=15 first formula returns 40, else 50. At the same time "else" means E3=7.5 as well, in this case second formula shall return 30. So, not clear what shall be returned, 50 or 30.
Thanks for helping me think. Here is the data I want to get into one formula and one cell - if possible. It is the number of hours (20, 30 or 40) I need the formula to return if it's a 7.5 hp course with more or less than 50 students or if it's a 15 hp course with more or less than 50 students.
7.5 hp <50 students = 20 hours |
15 hp <50 students = 30 hours |
7.5 hp >50 students = 30 hours |
15 hp >50 students = 40 hours |
- SergeiBaklanJan 18, 2020MVP
I see, thank you for the clarification. It could be
=IF( E3=7.5, IF(B3<=50,20,30), IF(E3=15, IF(B3<=50,30,40), 0 ) )
- MarieHelenaJan 18, 2020Copper Contributor
Ahhh, bliss - THANK YOU so much.
I wish I could return a favour, but still in learning mode. You have saved me hours of work!- SergeiBaklanJan 18, 2020MVP
MarieHelena , you are welcome