Forum Discussion

Janedb's avatar
Janedb
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's avatar
    HansVogelaar
    Apr 22, 2021

    Janedb 

    In A35:

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

    Fill down.

Janedb's avatar
Janedb
Iron Contributor
Apr 22, 2021
Thnx Hans, is there a way to do the same with the date?
HansVogelaar's avatar
HansVogelaar
MVP
Apr 22, 2021

Janedb 

In A35:

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

Fill down.

  • Janedb's avatar
    Janedb
    Iron Contributor
    Apr 22, 2021
    As always....you are a star. Thnx!!!

Resources