G Guest Jun 10, 2005 #1 How do I create a function that will add an amount according to the date? Like a late fee?
G Guest Jun 10, 2005 #3 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?
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?
