Forum Discussion
Rosa Hernandez
Oct 04, 2017Copper Contributor
Excel Formula, combining two IF statements
I need to string together two IF statements, =IF(C7>=70, C7*0.5) and =IF(C7<=69, C7*0.65), please help
SergeiBaklan
Jan 18, 2020MVP
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.
MarieHelena
Jan 18, 2020Copper Contributor
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