 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / March 2008Excel 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 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,  SignatureHTH, Barb Reinhardt > 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 [quoted text clipped - 35 lines] > > Matt On Mar 25, 9:51 pm, Barb Reinhardt <BarbReinha...@discussions.microsoft.com> wrote: > You could try something like this > [quoted text clipped - 47 lines] > > - Show quoted text - Thank you very much, this worked like a charm! Matt |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.