Forum Discussion
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
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 |
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 ) )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!MarieHelena , you are welcome