worksheet functions2

[Guest]

when i put in IFTODAY()-D4>10,SUM(C4,J4),0 it comes up false I also tried
IFTODAY()-D4>10,C4*5%,0) same thing. Here is an example of what I'm trying
to get:

C=Amt pd
D=date pd
J=late fee
K=bal due

Now I'm trying to get k to find the result of C+J if D is after the 6/10/05
so if i put $200 in C on the 11th then J should add $25 and K should equal
$225

 

[Guest]

=IF(TODAY()>D4,C4+J4,C4)



Regards,

Peo Sjoblom

 

[Guest]

iIleft out a column to add another amount but even when i put the formula you
gave me it just comes out blank or a number that doesnt add up to what it
should be.