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