a worksheet for training programs in which this formula is written
=IF(C5<1/1/1902,0,IF(C6>EDATE(C6,12),0,1))
If it's for training purposes then maybe it's being used as an example of
how not to write a formula!
IF(C6>EDATE(C6,12) will *never* be TRUE. There are only 2 possible results,
either FALSE or an error.
Here's what that is saying in plain English...
If the value of cell C5 is less than 1 divided by 1 divided by 1902 then
return 0. If the value of cell C5 is not less than 1 divided by 1 divided by
1902 then test the value of cell C6 to see if it is greater than the date of
C6 12 months later. If C6 is greater than the date of C6 12 months later
return 0 otherwise return 1.
1 divided by 1 divided by 1902 = 0.000525762355415352
It would be technically possible for C5 to be less than
0.000525762355415352.
That portion of the formula should be written like this:
=IF(C5<DATE(1902,1,1),0...
Or the preferred method, use a cell to hold the date then refer to that
cell:
C4 = 1/1/1902
=IF(C5<C4,0...
Let's assume C6 holds the date 1/1/2010.
EDATE(C6,12) = 1/1/2011
So:
1/1/2010 > 1/1/2011 is not possible and will never be TRUE.
It's hard to say what was meant by:
IF(C6>EDATE(C6,12)...
