If Function Also Using AND eg: If( ... AND ... ,X,Y)

P

Peter W S

Hello

I have a skight problem which neither the help system or knowledge base can
answer so I am hooping that one of you nice people can help

I am trying to gain a result in a cell whereby two conditions have to be met
before it decides on which answer to give. I have tried the following ...

=IF(C1="2F" AND G1<=TODAY(),"1"," ")

However, excel does not wawnt to accept the AND argument. and therefore I
experimented with the following function

=AND(C1="2F",G1<=TODAY())

This gives me one of two responses ... TRUE or invalid syntax. I cannot work
out which or what to use and how. I am now tearing my hair out in despair.
Can anyone please advise or help.

Using Excel XP V10

--
Peter W Soady
Tel: +44 (0)1 793 326666
Mob: +44 (0)7 813 123011

CONFIDENTIALITY This electronically transmitted mail is for the intended
recipient(s) only. If you have received this mail in error then you must not
use any, in part or in full, of the information contained herein. To do so
may be breaching the Data Protection Act 1998 and render you liable to
criminal proceedings. Please inform the sender immediately
VIRUS INFO This email was certified clean by Norton AV on leaving the
senders compuiter. The sender cannot be held responsible for any damage or
loss caused to your data for failure to scan this email
 
B

Bob Phillips

Pretty close

=IF(AND(C1="2F",G1<=TODAY()),1,"")


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
Top