View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Smith NC Mike Smith NC is offline
external usenet poster
 
Posts: 9
Default Simplification help

these formulas works fine but is there a simpler way to write them:
1.
IF(OR(Model!E6="L",Model!E6="B"),IF(OR(Model!L3=K7 ,Model!L3=K8
,Model!L3=K9,Model!L3=K10,Model!L3=K11,Model!L3=K1 2,Model!L3=K13
,Model!L3=K14,Model!L3=K15,Model!L3=K16,Model!L3=K 17,Model!L3=K18
,Model!L3=K19,Model!L3=K20),"0.15 PSIG",IF(OR(Model!C8="W",Model!C8="T"),"2
PSIG",IF(OR(Model!C8="M",Model!C8="R"),"0.65 PSIG"))),N18)

2.
=IF(Model!A2=70,"",IF(Model!E6="L",IF(Model!C8="M" ,IF(OR(Model!N5=L12
,Model!N5=L13,Model!N5=L14,Model!N5=L15,Model!N5=L 16,Model!N5=L17
,Model!N5=L18,Model!N5=L19),"0.15 PSIG","0.29
PSIG")),IF(Model!E6="H",IF(Model!C8="W","100
PSIG",IF(OR(Model!C8="T",Model!C8="M"),"85 PSIG")))))

3.
=IF(A2=250,"",IF(C8="R","",IF(C8="H","",IF(E6="H", ""
,IF(OR(AND(C8="W",E6="L",F6=-2),AND(C8="W",E6="B",F6=-2)
,AND(C8="T",E6="L",F6=-2),AND(C8="M",E6="L",F6=-2)),"","-WX")))))

Thanks for any help