Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Simplify this formula | Excel Worksheet Functions | |||
Simplify Formula | Excel Worksheet Functions | |||
Is there anyway to simplify this formula? | Excel Worksheet Functions | |||
simplify this formula | Excel Discussion (Misc queries) | |||
Simplify formula | Excel Worksheet Functions |