Forum Discussion

SergeiBaklan's avatar
SergeiBaklan
MVP
Jan 18, 2020

MarieHelena 

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's avatar
MarieHelena
Copper Contributor
Jan 18, 2020

SergeiBaklan 

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

 

 

  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Jan 18, 2020

    MarieHelena 

    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
   )
)

     

    • MarieHelena's avatar
      MarieHelena
      Copper Contributor
      Jan 18, 2020

      SergeiBaklan 

      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!

Resources