Forum home » Delegate support and help forum » Microsoft Excel Training and help » ANDIF
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
ANDIF
Resolved · High Priority · Version 2007
Reply Fri 8 Oct 2010, 13:18Delegate 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
For upcoming training course dates see: Pricing & availability
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
|