Dav,

I actually set it up this way =SUM(C18*0.00029)
A Column B Column
Loan Amount $522,000
Payment at Full Interest Rate: $3,489
Other Mortgages: $0
Insurance/month (.0029*Value) $151
Taxes/month (.001*Price) $522
Total CC Debt (Total*.05): $0
Total Vehicle Debt: $0 $0
Vehicle Payments/month: $0
Other Loans: $0
Payments/month: $0
Total Payments (Debt) $4,162

and it worked this way. But I will keep your equation as well. Forgot the
astrick represented multiplication.
--
Sincerely,

Biz Broker

Your Business has the POWER of our Business


"Dav" wrote:


I wan to Multiply a number in a cell I call A1 by .00029 and its answer
in A4
.. Then be able to add up the entire A column in A6.

in A4 =a1*0.00029
in A6 =sum(A:A)

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=509261