 |
 | 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 / New Users / November 2006conditional formulas
Please, I need help with these formulas . . . 1.) if worksheetC!C12 says "1" then I want worksheet D!E18 to say "1" , but if C!C12 says "2" then I want D!F18 to say "2" 2.) if worksheet G!C12 says "G", thenD!I31 should say "G", but if G!C12 says "F", then I want D!H31 to say "F" 3.) if A!C12 says "930-12" and A!D12 says either "U" or "L" then D!E2 should say "U" or "L", but if A!C12 says "12-230" & A!D12 says "U" or "L" then D!F2 should say either "U" or "L", but if A!C12 says "230-430" & A!D12 says "U" or "L" then D!G2 should say either "U" or "L", but if A!C12 says "430-7" & A!D says "u" or "L" then D!H2 should say "U" or "L", but if A!C12 says "7-9" & A!D12 sys "U" or "L", then D!I2 should say either "U" or "L". Thanks so much for your help with this!!! Homework. The simple answer to 1 is =c!c12 but I suspect you don't really mean that. Look in the help index for IF  SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > Please, I need help with these formulas . . . > 1.) if worksheetC!C12 says "1" then I want worksheet D!E18 to say "1" , [quoted text clipped - 14 lines] > A!D12 sys "U" or "L", then D!I2 should say either "U" or "L". > Thanks so much for your help with this!!! one way: 1) D!E18: =IF(C!C12=1,1,"") D!F18: =IF(C!C12=2,2,"") 2) D!I31: =IF(G!C12="G","G","") D!H31: =IF(G!C12="F","F","") 3) D!E2: =IF(AND(A!C12="930-12",OR(A!D12="U",A!D12="L")),A!D12,"") D!F2: =IF(AND(A!C12="12-230",OR(A!D12="U",A!D12="L")),A!D12,"") D!G2: =IF(AND(A!C12="230-430",OR(A!D12="U",A!D12="L")),A!D12,"") D!H2: =IF(AND(A!C12="430-7",OR(A!D12="U",A!D12="L")),A!D12,"") D!I2: =IF(AND(A!C12="7-9",OR(A!D12="U",A!D12="L")),A!D12,"") > Please, I need help with these formulas . . . > 1.) if worksheetC!C12 says "1" then I want worksheet D!E18 to say "1" , but [quoted text clipped - 8 lines] > A!D12 sys "U" or "L", then D!I2 should say either "U" or "L". > Thanks so much for your help with this!!! |
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.