Excel IF Function with AND and empty cell

zoog25

Active Member
Joined
Nov 21, 2011
Messages
350
Hello all,

I'm trying to write an IF state for a situation i'm looking into.

I have a Cell AQ3 in which i'm entering an if state. Here is the criteria for the if state.

1) It checks if a date stored in S3 - Today() date <> 0
2) It checks to see if cell AG3 is empty

Now the issue here is that there are a few conditions.
1) IF S3-Today() >= 0 But AG3 is empty then AQ3 = "Active"
2) IF S3-Today() >= 0 But AG3 is not empty then AQ3 ="Done"
3) IF S3-Today() <= 0 But AG3 is empty then AQ3 = "Expired"
4) IF S3-Today() <= 0 But AG3 is not Empty then AG3 = "Done"

I don't know if it is possible to do the above but please let me know how i can do this.
 

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
11,757
Office Version
2007
Platform
Windows
Try

=IF(AG3="",IF(S3-TODAY()>=0,"Active","Expired"),"Done")
 

Watch MrExcel Video

Forum statistics

Threads
1,099,362
Messages
5,468,175
Members
406,569
Latest member
Quest_

This Week's Hot Topics

Top