View Single Post
  #2   Report Post  
gls858
 
Posts: n/a
Default

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.

Unless you typed it incorrectly it should be

=IF(TODAY()-D410,SUM(C4,J4),0)
Notice the equal sign and the extra set of parenthesis.

gls858