why isn't this formula calculating correctly?
Hi Dave
See reply posted to your question on 07/10/06 18:13
=DATEDIF(3/31/2006,4/30/2006,"m") equals 0?
--
Regards
Roger Govier
"Dave F" wrote in message ...
Here's the formula:
=IF(I$6<$G14,"",IF($F14<0,"N/A",IF(DATEDIF($G14,I$6,"m")/$B$3*$F14$F14,"",DATEDIF($G14,I$6,"m")/$B$3*$F14)))
I6 is 4/30/2006, G14 is 3/31/2006, F14 is $85,968, B3 is 48
I think it should resolve to 1/48*$85,968 = $1,791. But excel is
calculating it as $0.00.
Thoughts?
--
Brevity is the soul of wit.
|