Forum Discussion

Anne Daigle's avatar
Anne Daigle
Copper Contributor
Mar 15, 2018

Multiple IF functions

Hello,

 

I'm trying to find a way to combine both formulae from D2 and D3 into one statement... any idea how I can do this? In other words, I need to see if B2=Breaks as needed; if so, then I want to refer to cells A2 to see =IF(A2<2;"1 to 2 breaks";IF(A2<4;"3 to 4 breaks";IF(A2>3:59;"5 to 6 breaks";""))). How do i combine both of them into one?

 

Please help.... Thanks!
Anne

 

 

  A B C D
1 Duration Breaks # of Breaks Formula
2 3:07 Breaks as needed 1 to 2 breaks =IF(A2<2;"1 to 2 breaks";IF(A2<4;"3 to 4 breaks";IF(A2>3:59;"5 to 6 breaks";"")))
3 3:07 Breaks as needed 1 to 2 breaks =IF(A3<2;"1 to 2 breaks";IF(A3<4;"3 to 4 breaks";IF(A3>4:60;"5 to 6 breaks";"")))
4 1:30 No breaks   =IF(B4="Breaks as needed";"A4";"")
Formulas & Functions
Need Help
  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Mar 15, 2018

    Hello Anne,

     

    Please try this formula:

    =IF(B2="Breaks as needed",IF(A2<TIME(2,0,0),"1 to 2 breaks",IF(A2<TIME(4,0,0),"3 to 4 breaks",IF(A2>TIME(3,59,0),"5 to 6 breaks"))),"")

    Put it in cell D2 and drag it down.

     

    Hope that helps

    Haytham

Resources