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
I've read all the replies to the intial question without being able to apply it successfully to my two formulas that I want to combine.
IF(AND(E3=15;B3>50)40;50)
IF(AND(E3=7,5;B3>50);30;20)
Both formulas work fine separately, but I need them to be in one cell, i.e. combined. How do I do?
Thanks!
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!
