ANDIF

Resolved · High Priority · Version 2007

Fri 8 Oct 2010, 13:18 Delegate MARIOS said...

MARIOS has attended:
Excel VBA Intro Intermediate course

ANDIF

This is a question for Mark Monroe who attended our site for an Excel 2007 course.

The first statement I know works but the second one does not as it appears not to recognise the specific date and therefore reports a true (1) answer on anything that satisfies the first criteria i.e. "Rented"

=IF(AND(J136="rented",S136>TODAY()),1,0)

=IF(AND(J136="rented",S136>08/10/2010),1,0)

How can I get it to recognise the specific date I will enter in the second part of the AND statement?

Please advise.

Thanks,
Marios

Mon 11 Oct 2010, 13:24 Trainer Mark said...

RE: ANDIF

Hi Marios,

The date part has to be specified either as the actual serial number of date, or by far the easiest, use the DateValue command.
e.g.
=if(and(A1="yes",A2>DateValue("12/5/10"),1,0)

hope that helps.

Mark

Hello xxxxxxxx,

Hope you enjoyed your Microsoft XXXXXX course with BEST Training.
Thank you for your question regarding XXXXXXXXXXXXX

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer

Excel tip:

Jumping Between Sheets in a Book

PgDn and PgUp keys scrolls up and down a screen page in most applications.

Ctrl+PgDn and Ctrl+PgUp keys jump from one sheet in your workbook to the next, up or down through the pages.

View all Excel hints and tips

ANDIF

ANDIF

RE: ANDIF

Excel articles

Excel tip:

Jumping Between Sheets in a Book