conditional 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!!!

conditional formulas
 

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

--
Don Guillett
SalesAid Software

"mrseje1" wrote in message
...
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!!!

conditional formulas
 

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,"")



In article ,
mrseje1 wrote:

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!!!