Dave Keister

Posts: n/a

Financial Calculation across sheets

Need some help with a formula.

Sheet1;
A1=$2200
A2=$150.00
A3= $1800
A4=SUM(A1:A3) answer is $4150

Sheet2;
A1=1029514
A2=2663427
A3=(A1/A2) answer is rounded two two decimal places (.39)

Sheet3;
A1=SUM(Sheet1!A4/(1-(Sheet2!A3+.1))) answer comes out $8082.38

Equation should calculate $8137.25 =4150/(1-(.39+.1)

How do I get this to calculate.

Any help would be appreciated.

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Financial Calculation Help Needed -- Annunity	Lomax	Excel Worksheet Functions	1	September 8th 05 04:48 AM
Calculation Setting in Excel	Stuart Bisset	Excel Discussion (Misc queries)	0	June 17th 05 09:54 AM
Question about financial calculation PMT	Peter Aitken	Excel Worksheet Functions	3	April 7th 05 01:18 PM
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets)	RICHARD	Excel Worksheet Functions	1	March 15th 05 05:49 PM
Multiple sheets selected	twa14	Excel Discussion (Misc queries)	2	December 21st 04 11:15 AM

All times are GMT +1. The time now is 12:23 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us