Simplify formula please
To start with, you don't need the second AND in each equation, as you're
already within an AND function, hence:
=IF(AND(OR($B2="FF00",$B2="BE00",$B2="LU00"),$E20 ,$L2<-0.5,$L2=-0.7),6,"") =IF(AND(OR($B2="FF00",$B2="BE00",$B2="LU00"),$E20 ,$L2<-0.7,$L2=-1),7,"")You could do things the long way & just say:=IF(AND(OR($B2="FF00",$B2="BE00",$B2="LU00"),$ E20,$L2<-0.5,$L2=-0.7),6,IF(AND(OR($B2="FF00",$B2="BE00",$B2="LU00") ,$E20,$L2<-0.7,$L2=-1),7,""))Another option is:=IF(AND(OR($B2="FF00",$B2="BE00",$B2="LU00"),$E 20),IF($L2=-0.5,"",IF($L2=-0.7,6,IF($L2=-1,7,""))),"")--David Biddulph"Iriemon" wrote in ...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 intoa 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
|