Re: Calculating Finance Charges

From: joeu2004@xxxxxxxxxxx
Date: 22 Jan 2007 10:50:25 -0800

lindadi wrote:

I am trying to calculate finance charges on an invoice at a rate of 1.8% per
month. This is to send to a customer. Can someone please tell me how to do
this. Thanks very much in advance!!

If A1 contains the balance due, the following computes one month's
finance charges:

=round(A1*1.8%, 2)

ROUND() rounds the amount to the cent, assuming a centidecimal currency
system (e.g. US).

If that formula is in A2, the total amount due is:

=A1+A2

.

Prev by Date: Re: Multiple Number Ranges Results in Text ('A' if 1-5, 'B' if 6-8
Next by Date: Re: Multiple Number Ranges Results in Text ('A' if 1-5, 'B' if 6-8, et
Previous by thread: Re: Multiple Number Ranges Results in Text ('A' if 1-5, 'B' if 6-8, et
Next by thread: Re: Subtact 2 dates to get the number without counting weekends?
Index(es):
- Date
- Thread

Relevant Pages

Re: Speaking of round inserts....
... The problem with round inserts for general purpose turning is that they make the widest chip possible for any given depth of cut. ... Grinding this thing would have cost more than you might believe, so we (mostly the customer; but I got to watch and help) tried hard turning with round inserts. ...
(alt.machines.cnc)
Performance PSQL 10
... This customer is now reporting, that our application is lagging very often for 5-20 seconds. ... We have checked other installations with near the same setup and never noticed that high CPU utilization and also note seeing that amount of threads being used. ... We have also tried with System Cache=off and Max Microkernal Memory Usage = 60 without any changes. ... 50 with total amount 108 GB via Transactional Btrieve ...
(comp.databases.btrieve)
Re: Wrong sum value after calculate with Percentage
... I need to have in 2 digit decimals. ... If you want to round, ... If let's say there is a Total amount of Hours that put into ...
(microsoft.public.excel.worksheet.functions)
Re: Wrong sum value after calculate with Percentage
... If you want an exact answer (within the 15 digit precision of Excel's ... calculations), then don't round. ... If you want to round, ... If let's say there is a Total amount of Hours that put into ...
(microsoft.public.excel.worksheet.functions)
How to access a field value in Access VB
... MILKMAN ROUNDS PROJECT: ... I have a simple project that has a customer table and a "Rounds" ... table that contains the round details for the round each customer ... field in the underlying dataset for the report. ...
(microsoft.public.access.formscoding)