Nashaat
 
Reply Thu 15 Aug, 2013 03:16 am
i have a customer and always delay of payment . the customer sales credit limet for the month have to settle on 20th of following month . and alawys delay more than 45 days and ther is a penalty .05% on daily basis how can i creat a excel formula
  • Topic Stats
  • Top Replies
  • Link to this Topic
Type: Question • Score: 1 • Views: 1,014 • Replies: 1
No top replies

 
jespah
 
  1  
Reply Thu 15 Aug, 2013 07:07 am
@Nashaat,
You want to calculate what is essentially daily compound interest. Try this link -
http://www.mrexcel.com/forum/excel-questions/313557-how-calculate-daily-compound-interest.html
0 Replies
 
 

Related Topics

Clone of Micosoft Office - Question by Advocate
Do You Turn Off Your Computer at Night? - Discussion by Phoenix32890
The "Death" of the Computer Mouse - Discussion by Phoenix32890
Windows 10... - Discussion by Region Philbis
Surface Pro 3: What do you think? - Question by neologist
Windows 8 tips thread - Discussion by Wilso
GOOGLE CHROME - Question by Setanta
.Net and Firefox... - Discussion by gungasnake
Hacking a computer and remote access - Discussion by trying2learn
 
  1. Forums
  2. » penalty
Copyright © 2024 MadLab, LLC :: Terms of Service :: Privacy Policy :: Page generated in 0.04 seconds on 04/26/2024 at 06:55:10