Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi!
I am trying to calculate the interest owned by a client. I need to do this using dates as the terms of sales a 1.5% after 30 days. My spreadsheet is set-up as follows: in F10 Current date, in A14 Invoice date, in F14 amount of sale and the amount is to be in F18. So the invoice date is July 14, 2005 and the amount is $428.00. Can someone please help me?!?! I"ve been working on this for over 3 hours and I cannot seem to get the proper answer. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
simple interest formula in excel | Excel Discussion (Misc queries) | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Interest formula on Personal Line | Excel Discussion (Misc queries) | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |