Forum Discussion

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 wan...

Formulas & Functions

Need Help

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