Multiple IF functions

[Anne Daigle]

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

[#2]

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