Apr 20 2021 03:38 AM
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?
Apr 20 2021 04:25 AM
Could you provide some information about the formulas involved?
Apr 21 2021 03:17 AM
@Hans Vogelaar Sample spreadsheet attached.
Apr 21 2021 03:36 AM
Thanks! See the attached version.
Apr 22 2021 03:27 AM
Apr 22 2021 03:50 AM
SolutionApr 22 2021 03:50 AM
SolutionIn A35:
=IF(B35="","",DATE(YEAR(A34),MONTH(A34)+1,1))
Fill down.