Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Financial Calculation across sheets
Hi Dave:
The problem is the .39 You have adjusted the display to present .39, but the value Excel is using is 0.386537345 In Sheet2,A3 use =ROUND(A1/A2,2) -- Gary's Student "Dave Keister" wrote: 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 |
#3
|
|||
|
|||
Financial Calculation across sheets
As was explained in your other thread 3 days ago, 1029514/2663427 is
0.3865..., not 0.39. If you want Excel to use 0.39 instead of the exact quotient, you need to either use =SUM(Sheet1!A4/(1-(ROUND(Sheet2!A3,2)+.1))) or on the menu select Tools|Options|Calculation and check "Precision as displayed". As a practical matter, if you do not understand or or otherwise having a problem with solutions given in a thread, it better to seek clarification within that thread instead of starting a new one. Jerry Dave Keister wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Financial Calculation Help Needed -- Annunity | Excel Worksheet Functions | |||
Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
Question about financial calculation PMT | Excel Worksheet Functions | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
Multiple sheets selected | Excel Discussion (Misc queries) |