How to Stop Running Turnaround Time

[emirahuhu]

Hi everyone, I was able to figure out how to produce a running TAT however, I am now running into the problem of stopping the running turnaround time for one of my columns. The short idea is that I want to have an If Statement nested inside my existing formula so that when my F column is not blank or not equal to 0, it will make my E column turn into zero. Here is the sample sheet:

Book2
	A	B	C	D	E	F	G	H
1	Date Today	Memo Routed	Memo Approved	Bank credited (date)	Running TAT	TAT
2	2/16/2023
3		2/14/2023			3
4		2/13/2023	2/15/2023		4			If F is blank or equal to 0 then E should keep calculating for the running TAT
5		2/9/2023	2/12/2023	2/14/2023	6	4		If F is not blank or not equal to 0 then E should turn to 0
Sheet1

Cell Formulas
Range	Formula
A2	A2	=TODAY()
E2:E5	E2	=IF($B2="","",NETWORKDAYS($B2,$A$2))
F3:F5	F3	=IF($D3="","",NETWORKDAYS($B3,$D3))

Any help is super appreciated thank you so much!

 

[justuptou]

Fulfil your two condition below,
1) If F is not blank or not equal to 0 then E should turn to 0
2) If F is blank or equal to 0 then E should keep calculating .............

Formula at Range E3
=IF($F3<>"",0,IF($F3<>0,0,IF($B3="","",NETWORKDAYS($B3,$A$2))))

 

[emirahuhu]

Hi justupto! Thank you so much for this. I ran into a problem with the Running TAT no giving me any numbers but your solution gave me the idea on how to make the running be 0 or blank if there was a number on the TAT!

Thank you so much! Here was the formula I ended up with:

=IF($F3<>"",0,IF($F3<>0,0,IF($B3="","",NETWORKDAYS($B3,$A$2))))

Wonderul help and your solution was such a helpful building block!

 

[emirahuhu]

Hi justupto! Thank you so much for this. I ran into a problem with the Running TAT no giving me any numbers but your solution gave me the idea on how to make the running be 0 or blank if there was a number on the TAT!

Thank you so much! Here was the formula I ended up with:

=IF($F3<>"",0,IF($F3<>0,0,IF($B3="","",NETWORKDAYS($B3,$A$2))))

Wonderul help and your solution was such a helpful building block!

Oops, pasted the wrong formula HAHAHA here was the final one I used: =IF($F4<>"",0,IF($B4="","",NETWORKDAYS($B4,$A$2)))

 

[justuptou]

Oops, pasted the wrong formula HAHAHA here was the final one I used: =IF($F4<>"",0,IF($B4="","",NETWORKDAYS($B4,$A$2)))

You are welcome.

I am not sure how to use NETWORKDAYS or idea on TAT.
I only share my experience on "if the value is Zero or blank" or else in formula ^.^