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
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
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 30, 2021

Mel4342 

Exactly, 0 means FALSE. If return TRUE/FALSE you may simply use =(E3+91)>F3.

  • Mel4342's avatar
    Mel4342
    Copper Contributor
    Apr 30, 2021
    That all makes a alot of sense. If I wanted to find AF4 dates that fell within 90 days before J4 only when J4 is equal to 1,1,2021 would it be something like this?

    =IF(and(j4>=Date(2020,1,1),j4>=90),1,0))
    Or am I off?
    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Apr 30, 2021

      Mel4342 

      I guess that will be

      =IF( (J4=Date(2020,1,1)*(J4 - AF4)<=90),1,0))

Resources