 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / June 2005Worksheet functions
How do I create a function that will add an amount according to the date? Like a late fee? Have a look in HELP index for SUMIF  SignatureDon Guillett SalesAid Software donaldb@281.com > How do I create a function that will add an amount according to the date? > Like a late fee? 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? SignatureRegards, Ron |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.