Forum Discussion

Iron Contributor

Apr 20, 2021

Solved

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 ...

excel

HansVogelaar
Apr 22, 2021
Janedb

In A35:

=IF(B35="","",DATE(YEAR(A34),MONTH(A34)+1,1))

Fill down.

HansVogelaar

MVP

Apr 20, 2021

Janedb

Could you provide some information about the formulas involved?

Janedb
Iron Contributor
Apr 21, 2021
HansVogelaar Sample spreadsheet attached.
Rental calculation.xlsm28 KB
- HansVogelaar
  MVP
  Apr 21, 2021
  Janedb
  
  Thanks! See the attached version.
  Rental calculation.xlsm23 KB
  - Janedb
    Iron Contributor
    Apr 22, 2021
    Thnx Hans, is there a way to do the same with the date?