Prev: EXCELL
Next: Tables in excel- bringing down formulas for new records.
From: afdmello on 16 May 2010 13:55
I saw a worksheet for training programs in which this formula is written
=IF(C5<1/1/1902,0,IF(C6>EDATE(C6,12),0,1))

can the function C6>EDATE(C6,12) can ever be true as the logic is refering
to the same cell

afd


 | 
Pages: 1
Prev: EXCELL
Next: Tables in excel- bringing down formulas for new records.