Worksheet functions

G

Guest

How do I create a function that will add an amount according to the date?
Like a late fee?
 
G

Guest

If you are asking for a way to calculate a late fee, here's one way:

A1: $100 (Invoice Amt)
B1: 05/25/2005 (Due Date)
C1: =IF(TODAY()-B1>10,A1*5%,0) (Late fee: in this case $5)

Does that get you on the right path?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The query cannot be completed. 1
Worksheet Functions 3
worksheet formulas 4
Sumif function 4
Access Query problem 1
How do I calculate interest and deduct late fees based on date pa. 1
VBA - retrieve data on last create named range from previous inserted named range 0
DataMacro problem after Splitting Access Database 2010 0

Top