Combining a OR and a AND in an IF statement

[Shu of AZ]

I need to add AND (t2<8) to this formula but can not make it work. Any ideas?

IF t2 is less than 8 and either G88=5.5 or g88=6 and so on. I have the OR
working but cannot get the AND to fit


=IF(OR(G88=5.5,G88=6,G88=6.5,G88=7,G88=7.5,G88=9,G88=9.5,G88=10,G88=11,G88=12),((VLOOKUP(G88,CU191:CZ207,2,FALSE)-(I88*11))/(M88)))

 

[JMB]

Try
=IF(AND(T2<8,OR(G88={5.5,6,6.5,7,7.5,9,9.5,10,11,12})),((VLOOKUP(G88,CU191:CZ207,2,FALSE)-(I88*11))/(M88)))

 

[joeu2004]

I need to add AND (t2<8) to this formula but can not make it work. Any ideas?

IF t2 is less than 8 and either G88=5.5 or g88=6 and so on. I have the OR
working but cannot get the AND to fit

=IF(OR(G88=5.5,G88=6,G88=6.5,G88=7,G88=7.5,G88=9,G88=9.5,G88=10,G88=11,G88=12),((VLOOKUP(G88,CU191:CZ207,2,FALSE)-(I88*11))/(M88)))

=if( and(T2<8, or(...)), vlookup(...) )

 

[kassie]

=IF(AND(T2>8,OR(G88=5.5,G88=6,G88=6.5,G88=7,G88=7.5,G88=9,G88=9.5,G88=10,G88=11,G88=12)),((VLOOKUP(G88,CU191:CZ207,2,FALSE)-(I88*11))/(M88)))