Help with if(and) formula please

[Jmoz092]

I'm in need of a formula that compares a couple things and gives an answer, but I'm not having any luck. Any help would be appreciated.

Begin Date	End Date	true/false	today	active/expired
11-1-17	11-30-17	true	=today()	active
		false	=today()	n/a
11-1-17	11-2-17	true	=today()	expired

<tbody>
</tbody>

I have 2 columns with a begin and end date.
I have a static cell that contains =today().
I have a column that contains true or false values

I need (in the active/expired/na column) to compare those in the active/expired column.

If the end date is less than today, = active
if the true/false column is false, = n/a
if the end date is in the past (compared to today), = expired

Thank you

 

[estevaoba]

Assuming your data are in range A1:E4, try this:

[TABLE="width: 87"]
<tbody>[TR]
  [TD="width: 87"]=IF(C2="False","n/a",IF(B2>=D2,"active","expired"))[/TD]
[/TR]
</tbody>[/TABLE]

 

[NiMip]

Hi there, I think your description is a little confused, because "If the end date is less than today" and "if the end date is in the past (compared to today)" are the same thing? But I think I know what you're after. Try the following:

	A	B	C	D	E
1	Begin Date	End Date	true/false	today	active/expired
2	11/01/2017	11/30/17	TRUE	28/11/2017	=IF(C2,IF(B2>D2,"Active","Expired"),NA())
3			FALSE	28/11/2017	Fill from above
4	11/01/2017	11/02/2017	TRUE	28/11/2017	Fill from above

<tbody>
</tbody>

 

[Jmoz092]

Thank you for the responses. @NiMip, that works. Thank you for seeing past my poor explanation