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.
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.