if statement with and condition

**gasniger** · 01-24-2015, 09:02 AM

Dear experts

I would like to have your help regarding the below formula.

I have three dates example

1st date - 21/01/2014 (column A1)
2nd date - 21/01/2014 (column B1)
3rd date - 21/01/2014 (column C1)

I am trying to write an if statement - if 1st date is equal to 2nd date and both of them are either equal or less than 3rd date, give me answer "Due", otherwise "NA".

I have written the below formula but not working.
=IF(AND(A1=B1)<=C1,"Due","NA")

Please help.

**Glenn Kennedy** · 01-24-2015, 09:13 AM

Try this out

=if(and(A1<=c1,B1<=c1),"Due","NA")

**bebo021999** · 01-24-2015, 01:40 PM

Try:

=IF(AND(A1=B1,A1<=C1),"Due","NA")

**gasniger** · 01-24-2015, 08:47 PM

Thanks bebo021999, your formula works perfectly. Thanks Glenn as well for helping.

**gasniger** · 01-24-2015, 08:54 PM

thanks everyone, it is now solved

if statement with and condition

LinkBack

Thread Tools

Rate This Thread

Display

if statement with and condition

Re: if statement with and condition

Re: if statement with and condition

Re: if statement with and condition

Solved: if statement with and condition

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] 23 condition IF statement possible?

if statement with condition

condition:IF statement

IF statement more than one condition

Condition:If Statement

Bookmarks

Bookmarks

Posting Permissions