Formula return black if answer is 0


HI All, I am working with a lease agreement and want the formula to stop calculating as soon as the amount gets to zero and then leave it as blank cells onwards. The date should also return as black as soon as the amount gets to zero, If possible?






6 Replies


Could you provide some information about the formulas involved?

@Hans Vogelaar Sample spreadsheet attached.


Thanks! See the attached version.

Thnx Hans, is there a way to do the same with the date?
best response confirmed by Janedb (Contributor)


In A35:


Fill down.

As are a star. Thnx!!!