worksheet functions2
 

when i put in IFTODAY()-D410,SUM(C4,J4),0 it comes up false I also tried
IFTODAY()-D410,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

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



Regards,

Peo Sjoblom


"Nadji" wrote:

when i put in IFTODAY()-D410,SUM(C4,J4),0 it comes up false I also tried
IFTODAY()-D410,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

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.

"Peo Sjoblom" wrote:

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



Regards,

Peo Sjoblom


"Nadji" wrote:

when i put in IFTODAY()-D410,SUM(C4,J4),0 it comes up false I also tried
IFTODAY()-D410,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