Formula to exclude data when using Today

[Stryker2013]

I have a ticketing system that has a status of all tickets. I also want to use the Today function to calculate the life of the tickets. I want to exclude the tickets that are in a specific status.

A	B	C	D​	E	F
title	status	priority	owner​	create date	life
item 1	Backlog	High	me​	9/20/2023 11:52	5.51
item 2	doing	high	me​	9/20/2023 11:53	5.50

The formula I am using in column F is =Today()-E2. What I want is to add to the formula to ignore any calculation of column E and F if column B contains text I want to ignore as in this case it is "Backlog". If the date is ignored I would like the formula to insert in column F the Text "NA".


Can anyone assist?

 

[awoohaw]

Not sure if i understand. But you want to put NA in the cell if "Backlog" is in B2, other wise subtract the date in E2 from TODAY()?
If so, try:

IF(B2="Backlog",NA(),Today()-E2)

If this isn't correct please post an example of TRUE and FALSE conditions and/or better explain the condition.

 

[ExceLoki]

try this

Book1
	A	B	C	D	E	F
1	title	status	priority	owner	create date	life
2	item 1	Backlog	High	me	9/20/2023 11:52	NA
3	item 2	doing	high	me	9/20/2023 11:53	5.50
Sheet1

Cell Formulas
Range	Formula
F2	F2	=IF(B2="Backlog","NA",TODAY()-E2)
F3	F3	=IF(B3="Backlog","N/A",TODAY()-E3)