Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Please help
0 views
Skip to first unread message
Tamecia Medley
Sep 11, 2003, 8:49:12 PM9/11/03
to
I have a business right and I wanted to know is their any
way like if my customers do not pay their bills on time
that Excel could calculate a interest rate for me every
thirty days if I let the computer know that they have not
paid
way like if my customers do not pay their bills on time
that Excel could calculate a interest rate for me every
thirty days if I let the computer know that they have not
paid
rick
Sep 11, 2003, 11:02:59 PM9/11/03
to
I'm not sure exactly what you mean it sounds like there is
a number of ways you can do what I think you want to do.
An IF,AND formula may be the easiest. if there is no
payment in the amount paid column after 30 days from
billing date then add interest to total bill
a number of ways you can do what I think you want to do.
An IF,AND formula may be the easiest. if there is no
payment in the amount paid column after 30 days from
billing date then add interest to total bill
=if(and(now()-A>30),(B=""),c+interest amount,"")
a= billing date cell
b= amount paid cell
c = billing amount cell
the total of this formula would be the new billing amount
>.
>
0 new messages