Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Discussion (Misc queries) > Excel Version Problem
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 15
Default Excel Version Problem
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
Reply With QuoteReply With Quote
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 3,355
Default Excel Version Problem
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



"RemyMaza" wrote:

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

Reply With QuoteReply With Quote
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 15
Default Excel Version Problem
On Mar 25, 9:51*pm, Barb Reinhardt
wrote:
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



"RemyMaza" wrote:
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- Hide quoted text -

- Show quoted text -

Thank you very much, this worked like a charm!

Matt
Reply With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Version Problem Mian_Ghous Excel Worksheet Functions 2 November 19th 07 12:31 PM
Version Problem Mian_Ghous Excel Worksheet Functions 0 November 19th 07 05:24 AM
Recover earlier version of excel sheet after new version saved? stephanie38 Excel Discussion (Misc queries) 3 June 17th 05 03:52 AM
How can I update the version of Excel 2000 9.0 to version 10.0 Ramsey Can Excel Discussion (Misc queries) 1 May 11th 05 03:28 PM
version problem Lisa Excel Discussion (Misc queries) 4 April 1st 05 06:57 PM


All times are GMT +1. The time now is 06:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Contact Us ExcelBanter forum home Privacy Statement