Worksheet functions

N

Nadji

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

Ron Coderre

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

Small Thick "Bar" Below Last Typed Line ? 0
Resource name inside resource sheet: per person, work per hours per week 0
Office365 Family + TXT or MX Domain 0
Status and % complete of predecessor task 0
Dropdown with signatures 1
Sumif function 4
Add-Ins for Outlook (Mac) ? 0
Quick Parts and Formatting Question 1

Top