RE: worksheet function

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thanks so much half of the formula is working. When I put ithe formula in J4
it leaves the box blank even though I changed the date. The actual late fee
is $25 not 5% I just took a random number($200) I need a formula for J4 to
pick up on the date and automatically add $25.
Example:
C=amt pd
D=date pd
E=monthly amt
J=late fee
K= bal due

now I need for J to add $25 late fee if D is later than the 10th and K to
also recognize if Dis after the 10th then add C,E,J but if not then K will
equal zero. Is that possible or am I asking too much. ;-} Thanks so much.

"Nadji" wrote:

> 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.
.

Quantcast