Struggling with extra condition on IF

[slam]

I have the following formula which is working perfectly for its original use case.

=IF(ISBLANK(I2),"NEVER",(TODAY()-I2))

I now need to add another condition to it where if I2 ISBLANK AND C2 contains the text "Preparation", it should display "N/A".

I still want it to do as it does for when C2 does not contain "Preparation", which is to display "NEVER"

Any help will be GREATLY appreciated!

<3

 

[Snakehips]

@slam is this what you are wanting?

=IF(ISBLANK(I2),IF(C2="Preparation","N/A","NEVER"),(TODAY()-I2))

 

[slam]

Perfect, thank you!