Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / December 2007

Tip: Looking for answers? Try searching our database.

Inserting a value based on a calculation from another sheet

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
amir.companieh@gmail.com - 18 Dec 2007 21:32 GMT
Hi all
I have a sheet that performs a series of calculations based on a
single value and culminating in another single value.  Also the series
of calculations is too complicated and long and numerous to do in a
single calculation.  What I have is, in another sheet, I have a range
of that single initial value, from -90% to +90% of the initial value,
and I'd like to somehow calculate that value resulting from all the
various initial values and insert them in the first sheet...how can i
do that?

for example:  sheet A contains the range of initial values and the
result of the calculations performed in sheet B

Percentage     Initial Value     Result
-90%              10
-80%              20
...                  ....
0%                100                  300
10%              110
20%              120
...                  ...
90%              190

sheet B: a series of calculations based on the initial value.  Ex:
initial value is set to 100 and results after a long series of
calculations is 300...

Now i'd like to assign something to the -90% row of the Result column
in sheet A such that it would (in the background?) insert 10 into the
initial value of sheet B, do the calculations, and return that final
value to that locations...any ideas?
Niek Otten - 18 Dec 2007 22:30 GMT
Use the Data>Table command. Look in Help for instructions.
It is a bit of careful work to set up, but it works perfectly.

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi all
| I have a sheet that performs a series of calculations based on a
[quoted text clipped - 27 lines]
| initial value of sheet B, do the calculations, and return that final
| value to that locations...any ideas?
amir.companieh@gmail.com - 18 Dec 2007 23:18 GMT
Hi Niek,
Do you know if all the values, formulas, calculations need to be in
the same sheet?  I get an input reference value invalid error and i've
read some posts on other websites that indicated everything needed to
be in one sheet...is that true?  that seems awfully messy...is there a
workaround?  in my particular case, there is a sheet A that contains
the value I'm trying sweep through, a sheet B that has the
calculations by referencing that value, and a sheet C that i've put in
that has in one column the range of values i'm trying to sweep thru in
one column, and in the adjacent column, the formula (this is the
layout recommended in the help)..any ideas what i'm doing wrong to get
that error?

> Use the Data>Table command. Look in Help for instructions.
> It is a bit of careful work to set up, but it works perfectly.
[quoted text clipped - 38 lines]
> | initial value of sheet B, do the calculations, and return that final
> | value to that locations...any ideas?
Niek Otten - 19 Dec 2007 10:15 GMT
I have an article describing how to do this, but it's a bit lengthy so I'll mail you privately, if you don't mind.

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi Niek,
| Do you know if all the values, formulas, calculations need to be in
[quoted text clipped - 51 lines]
| > | initial value of sheet B, do the calculations, and return that final
| > | value to that locations...any ideas?

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.