Excel Version Problem

[RemyMaza]

Does anyone know how to change this code to work in Excel '03? It
works great in '07 but I think b/c the formula is too long my
associates cannot open it on their workstations.

Here is the code:

=(IF(AND(IN!C8="X",IN!L8="X",IN!AI8="X"),"D15120",IF(AND(IN!C8="X",IN!
L8="X",IN!AJ8="X"),"D20120",IF(AND(IN!D8="X",IN!L8="X",IN!
AI8="X"),"G15120",IF(AND(IN!D8="X",IN!L8="X",IN!
AJ8="X"),"G20120",IF(AND(IN!E8="X",IN!L8="X",IN!
AI8="X"),"IG15120",IF(AND(IN!E8="X",IN!L8="X",IN!
AJ8="X"),"IG20120",IF(AND(IN!F8="X",IN!L8="X",IN!
AI8="X"),"SW15120",IF(AND(IN!F8="X",IN!L8="X",IN!
AJ8="X"),"SW20120",IF(AND(IN!F8="X",IN!M8="X",IN!
AI8="X"),"SW15277",IF(AND(IN!F8="X",IN!M8="X",IN!
AJ8="X"),"SW20277",IF(AND(IN!G8="X",IN!L8="X",IN!
AI8="X"),"SW315120",IF(AND(IN!G8="X",IN!L8="X",IN!
AJ8="X"),"SW320120",IF(AND(IN!G8="X",IN!M8="X",IN!
AI8="X"),"SW315277",IF(AND(IN!G8="X",IN!M8="X",IN!
AJ8="X"),"SW320277",IF(AND(IN!H8="X",IN!L8="X",IN!
AI8="X"),"SW415120",IF(AND(IN!H8="X",IN!L8="X",IN!
AJ8="X"),"SW420120",IF(AND(IN!H8="X",IN!M8="X",IN!
AI8="X"),"SW415277",IF(AND(IN!H8="X",IN!M8="X",IN!
AJ8="X"),"SW420277",IF(AND(IN!I8="X",IN!L8="X",IN!
AI8="X"),"S15120",IF(AND(IN!I8="X",IN!L8="X",IN!
AJ8="X"),"S20120",IF(AND(IN!I8="X",IN!L8="X",IN!
AK8="X"),"S30120",IF(AND(IN!I8="X",IN!N8="X",IN!
AI8="X"),"S15240",IF(AND(IN!I8="X",IN!O8="X",IN!
AI8="X"),"S15208",IF(AND(IN!I8="X",IN!N8="X",IN!
AJ8="X"),"S20240",IF(AND(IN!I8="X",IN!N8="X",IN!
AK8="X"),"S30240",IF(AND(IN!I8="X",IN!N8="X",IN!
AL8="X"),"S50240",IF(AND(IN!I8="X",IN!O8="X",IN!
AJ8="X"),"S20208",IF(AND(IN!I8="X",IN!O8="X",IN!
AK8="X"),"S30208",IF(AND(IN!I8="X",IN!O8="X",IN!
AL8="X"),"S50208",""))))))))))))))))))))))))))))))



Any help would be very much appreciated!

Matt

 

[Barb Reinhardt]

You could try something like this

=IF(C8="X","D","")&IF(D8="X","G","")&IF(E8="X","IG","") &IF(AI8="X","15","")
&IF(AJ8="X","20","") & IF(L8="X","120","")

I didn't get through the whole thing,

 

[RemyMaza]

You could try something like this

=IF(C8="X","D","")&IF(D8="X","G","")&IF(E8="X","IG","") &IF(AI8="X","15","")
&IF(AJ8="X","20","") & IF(L8="X","120","")

I didn't get through the whole thing,
--
HTH,
Barb Reinhardt







- Show quoted text -

Thank you very much, this worked like a charm!

Matt