| View previous topic :: View next topic |
| Author |
Message |
sweitx
Newbie
Joined: 30 Apr 2006
Posts: 3
|
 Posted: Sun Apr 30, 2006 12:59 am Post subject: Using spreadsheet as a function... |
 |
|
Not sure anyone will understand this, but help will be appreciated.
I want to use my spreadsheet as a function with the effect of something like this.
Say I setup a spread sheet that takes an input in cell A5 and gives an output in cell B10 (after quite a lot of intermediate calculation across other cells).
I want to vary A5 across several values listed in cell A1 to E1, and store the result from B10 in A2 to E2.
So its something like...
Plug A1 into A5.
Get result from B10 and place it in A2.
Plug B1 into A5
Get result from B10 and place it in B2.
and so on...
Can Openoffice calc do this? |
|
| Back to top |
|
 |
9point9
Moderator
Joined: 31 Aug 2004
Posts: 3875
Location: UK
|
| Posted: Sun Apr 30, 2006 1:13 am Post subject: |
|
|
Yes.
In 15 put something like =(A1+1) for instance. Then enter other functions referencing that down the sheet.
_________________
Arch Linux
OOo 3.2.0
OOoSVN, change control for OOo documents:
http://sourceforge.net/projects/ooosvn/ |
|
| Back to top |
|
|
sweitx
Newbie
Joined: 30 Apr 2006
Posts: 3
|
| Posted: Sun Apr 30, 2006 1:28 am Post subject: Confused... |
|
|
Sorry, I don't understand what you mean, could you be more specific?
Btw, the spreadsheet that does the calculation consist of around 200 cells. And that's just for 1 input and 1 output. |
|
| Back to top |
|
|
9point9
Moderator
Joined: 31 Aug 2004
Posts: 3875
Location: UK
|
|
| Back to top |
|
|
sweitx
Newbie
Joined: 30 Apr 2006
Posts: 3
|
| Posted: Sun Apr 30, 2006 4:15 pm Post subject: Financial calculation... |
|
|
| I'm calculating the effect of several financial decision over variable time. |
|
| Back to top |
|
|
noranthon
Super User
Joined: 07 Jul 2005
Posts: 3318
|
|
| Back to top |
|
|
carl
Super User
Joined: 21 Apr 2003
Posts: 920
Location: Germany
|
| Posted: Mon May 01, 2006 4:49 am Post subject: |
|
|
| Quote: | So its something like...
Plug A1 into A5.
Get result from B10 and place it in A2.
Plug B1 into A5
Get result from B10 and place it in B2.
and so on... |
| Quote: | | I'm calculating the effect of several financial decision over variable time. |
I would create the formula cells (all 200) so that the data entered in A1 is collected and processed using variables (like% inflation,%growth, %interest, %discount rates) which are entered in cells A3 to A6.
For the result make cell A2 = B10.
For comparison purposes you need to copy the whole thing to a new set of columns
You end up with a big sheet showing in A1 to A6 start value, end value ,% inflation,%growth, %interest, %discount rates.
and in col B1 to B6 other values for start value, end value ,% inflation,%growth, %interest, %discount rates.
_________________
carl
Using OpenOffice.org 2 on XP sp2 |
|
| Back to top |
|
|
|
