Thanks all for the help!

Eduardo: I appreciate the formula help, yours is very easy to "read" and
makes following the logic simple. I used yours to validate the others.

NVBC: Your formula is shorter and is also easy to read, I'm actually
currently using this one.

David: Yours is the shortest and I will probably eventually use yours, but
for now, trying to follow the logic is more difficult. Once I get it all
validated, I'll switch them to your version. ( I have several more conditions
I have to test for)


THANKS ALL !

Irie!

"Iriemon" wrote:

I am getting confused trying to simplify these two formulas into one. I
currently have them in two separate cells and would like to get them into a
single cell.

=IF(AND(OR($B2="FF00",$B2="BE00",$B2="LU00"),$E20 ,AND($L2<-0.5,$L2=-0.7)),6,"")

=IF(AND(OR($B2="FF00",$B2="BE00",$B2="LU00"),$E20 ,AND($L2<-0.7,$L2=-1)),7,"")


As you can see, the only difference is in the L2 values and the value to
return. I'm getting lost!

Thanks

Irie