Change a #NUM! to a text ?

Unsolved

So I am doing a table with "datedif" formulas and when a date is negative, it's gives the #NUM! error. What I would like to do is have the error becoming a text I chose , that would be "expired".

​

I am a very very beginner in Google Sheet so please, be kind.

​

Also, could I make the cell have different colors depending on the answer they give ?

Posted Aug 15, 2023, 9:13 AM UTC

11
Loading comments…