If multiple function with different results.

[Addictions]

Hello,

I am trying to make "if" formula which return different results based on value in one cell.

This is the formula I have right now:

=IF(A3="Open",NETWORKDAYS(G3,TODAY()),IF(A3="Closed",NETWORKDAYS(G3,H3),IF(A3="Escalated to LTA",NETWORKDAYS(G3,I3))))))
It returns calculation based on A3 cell value if it is "Open","Closed" or "Escalated to LTA".
However what I'm trying to achieve and cannot do is:

-IF(A3="Open",NETWORKDAYS(G3,TODAY()) When G3 is empty to return value "Missing absence date".
-IF(A3="Closed",NETWORKDAYS(G3,H3) When H3 is empty to return value "Missing RTW date".
-IF(A3="Escalated to LTA",NETWORKDAYS(G3,I3) When I3 is empty to return value "Missing LTA date".

How can I make this formula working in one cell. Please if anyone can advise.

Best regards

[Pete_UK]

It becomes a bit messy, but try this:

=IF(G3="","Missing absence date",IF(A3="Open",NETWORKDAYS(G3,TODAY()),IF(A3="Closed",IF(H3="","Missing RTW date",NETWORKDAYS(G3,H3)),IF(A3="Escalated to LTA",IF(I3="","Missing LTA date",NETWORKDAYS(G3,I3)),""))))

Hope this helps.

Pete

[Haseeb Avarakkan]

Hello,

Also another one for try,

=IF(N(INDEX(G3:I3,MATCH(A3,{"Open","Closed","Escalated to LTA"},0))),NETWORKDAYS(G3,CHOOSE(MATCH(A3,{"Open","Closed","Escalated to LTA"},0),TODAY(),H3,I3)),"Missing "&A3&" date")

[Addictions]

This works. Thank you very much. I need to analyze it and see what wrong I was doing.

[Addictions]

Haseeb A,

If you could give a quick brief explanation of how does mechanism of this formula works It would be very grateful. It would really help out in the future