Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ARE THERE CONDITIONAL FORMULAS TO CHANGE TEXT COLOR? | Excel Worksheet Functions | |||
Conditional use of formulas | Excel Worksheet Functions | |||
Using MIN in Conditional Format for cells with Formulas | Excel Discussion (Misc queries) | |||
conditional formulas | Excel Worksheet Functions | |||
Help Using Formulas in Conditional Formatting | Excel Discussion (Misc queries) |