Simplify formula please
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
|