If statement (possibly)

[Sawdeeka01]

Hello,

I am hoping you could assist me please. I have the below table and formula which is calculating the Time to Convert between columns A and B, which is working great for me. I need to add in a consideration to the formula however I am unsure how to. Is there anyone who could advise how I am best to calculate the Time to Convert (column D) but only when Converted is indicated (column C). My current formula is calculating everything however 'Not converted' needs to be excluded from the calculation.

I am hoping this makes sense!

My formula is: =IF(COUNT(A3,B3)<2,"",NETWORKDAYS(A3,B3,holidays))

Thank you in advance!

Rox

 

[Skyybot]

Try this

=IF(AND(COUNT(A3,B3)<2,C3="Converted"),"",NETWORKDAYS(A3,B3,holidays))

 

[Sawdeeka01]

Try this

=IF(AND(COUNT(A3,B3)<2,C3="Converted"),"",NETWORKDAYS(A3,B3,holidays))

Hi,
Thank you however this isn't working, it is still calculating the 'Not converted' and is also populating the blank cells which I don't want...

 

[AhoyNC]

Try

IF(OR(C3="Not converted",B3="",A3=""),"",NETWORKDAYS(A3,B3,holidays))

 

[Sawdeeka01]

Try

IF(OR(C3="Not converted",B3="",A3=""),"",NETWORKDAYS(A3,B3,holidays))

Thank you so much, this worked!

Have a fantastic day!

 

[AhoyNC]

You're welcome thanks for the feedback.