Multiple conditional statements in one cell?

[chanson329]

I need one cell to be subject to the followingconditional statements and just can't get the formula correct. Basically I need the cell to calculate three different conditions
=if(l8<10,0,l8)<o></o>
=if(l8>=10,and(c8>15),l8,0)<o></o>
=if(l8>=20,and(c8<15),l8,0)<o></o>

 

[shyy]

Maybe

=IF(L8>10,L8,IF(AND(L8>=10,C8>15),L8,IF(AND(L8>=20,C8<15),L8,0)))

 

[joemeshuggah]

Try this...

=IF(L8>=20,IF(C8<15,L8,0),IF(L8>=10,IF(C8>15,L8,0),0))

 

[chanson329]

I reworked things a bit and actually the following twostatements work a bit better. I thinkhowever that the two conditions will conflict and I can’t seem to get thesyntax correct.<o></o>
If(c7>=15,and(l7>=10)*l7,0))<o></o>
If(c7<15,and(l7>=20)*l7,0))<o></o>

 

[shyy]

Your syntax is indeed wrong, something like

=IF(AND(logical 1, logical 2),true,false

 

[chanson329]

Thanks, having a bad day and brain doesn't seem to want to cooperate.....

 

[shyy]

Excel 2010
	A	B	C
1	9		0
2	11		11
3	11	16	11
4	21	14	21
Sheet3

Cell Formulas
Range	Formula
C1	=IF(AND(A1>=10,B1>15),A1,IF(AND(A1>=20,B1<15),A1,IF(A1<10,0,A1)))
C2	=IF(AND(A2>=10,B2>15),A2,IF(AND(A2>=20,B2<15),A2,IF(A2<10,0,A2)))
C3	=IF(AND(A3>=10,B3>15),A3,IF(AND(A3>=20,B3<15),A3,IF(A3<10,0,A3)))
C4	=IF(AND(A4>=10,B4>15),A4,IF(AND(A4>=20,B4<15),A4,IF(A4<10,0,A4)))