Forum Discussion
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 date in AF4 but it does not always work. Could it be because AF4 is the results of an active vlookup? Please help if you can.
Thank you
=IF(J4+91>AF4,1,0) I am expecting to get a 1 if the date in j4 +91 is > than the date in AF4 but it does not always work. Could it be because AF4 is the results of an active vlookup? Please help if you can.
Thank you
7 Replies
Mel4342 Your formula should work as desired. Can you giv an example of when it "does not work".
- 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
