I
Iriemon
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"),$E2>0,AND($L2<-0.5,$L2>=-0.7)),6,"")
=IF(AND(OR($B2="FF00",$B2="BE00",$B2="LU00"),$E2>0,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
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"),$E2>0,AND($L2<-0.5,$L2>=-0.7)),6,"")
=IF(AND(OR($B2="FF00",$B2="BE00",$B2="LU00"),$E2>0,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