Thread
:
conditional formulas
View Single Post
#
2
Posted to microsoft.public.excel.newusers
Don Guillett
external usenet poster
Posts: 10,124
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!!!
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett