Help w/ adding a formula to existing formula.

[Relli]

I haven't been able to find an answer by viewing other people's questions. So I am hoping I can get this answered.

I am currently using the following formula in a cell which is working well. =IF(NOT(ISBLANK(F19)),[@[ENROLLMENT DATE]]-[@[REFERRAL DATE]],TODAY()-[@[REFERRAL DATE]])

I want to add this formula to the above formula if possible =IF($H2="Closed",$G2,""). How do I do this? This last formula would need to override the ISBlANK part if the G2 cell has the text "closed".

Does this make sense? Thanks much!

 

[NARAYANK991]

Hi ,

I am not sure I have understood you , but see if this is OK.

Narayan

 

[Relli]

Thank you so much! You solved it!