Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula simplification | Excel Worksheet Functions |