Forum Discussion

Mel4342's avatar
Mel4342
Copper Contributor
Apr 30, 2021

Excel formula question.

I have quite a few excel formula questions considering I am new to it. But here's my first one. I have the formula =IF(J4+91>AF4,1,0) I am expecting to get a 1 if the date in j4 +91 is > than the dat...
excel
Formulas and Functions
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Apr 30, 2021

Mel4342 Your formula should work as desired. Can you giv an example of when it "does not work".

  • Mel4342's avatar
    Mel4342
    Copper Contributor
    Apr 30, 2021
    For example, it works when j is 12/1/2016. But when j is 8/1/2019 and f is 11/12/2019 it does not. But there are other examples too
    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Apr 30, 2021

      Mel4342 

      Between days there are 103 days, it works correctly

      • Mel4342's avatar
        Mel4342
        Copper Contributor
        Apr 30, 2021
        I am new to excel but doesn't 1 mean it's true and 0 means its false

Resources