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

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

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

Try this:

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

Hope this helps.

Pete

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

Peter,

Try

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


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Peter W S" wrote in message
...
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

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

Pretty close

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


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Peter W S" wrote in message
...
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