Displaying function results

  • Thread starter Thread starter Anna
  • Start date Start date
A

Anna

I want to display the results of certain calculations on a
table but I'm having a lot of trouble doing it. Please
help! It is kind of difficult to explain the problem but
I am going to try.

I have a worksheet with 3 tables. The first table is
where I input data, the second does the calculation, and
the tird displays the results.

I have a cell in the first table where I input a
deductible number, lets say cell b14. I input different
deductible numbers in here for different results that
calculates on the next table. This table pulls data from
another worksheet.


The next table is where i want to display the results of
the different deductibles. Let's say $50,000, $75,000 and
$100,000.

I have functions set in the 50k row of table 3 that if b14
is 50k then put these values in here. Then in the 75k row
I have the function set to put the value in here if b14
was 75k.

The problem is that when I change b14 to 50k....the 75k
and 100k row in table 3 goes blank. When I change b14 to
75k the 50k and 100k row goes blank. So there can only be
one row displaying the value depending on what b14
is. I want all 3 rows to be displayed no matter what I
put in b14. Like after it display values in the 50k row,
is there any way of making the vlaues stay even though I
change b14 to a different number?

I really need an answer. I know it sounds confusing. If
anyone could please get back to me I would really
appreciate it. Thanks!

Anna
 
I really need an answer. I know it sounds confusing.

You think so?? :-)

I don't know if this will answer your question or not to be honest, but take a look anyway and see
if it is what you are after:- Go to help and type in 'one-variable' and hit search. This will
throw up results for a one-variable data table and a two variable data table. This allows you take
a series of calculations, and then have a multitude of results returned in a table assuming that
one (or two) of the variables were changed to whatever list you give it, eg

Assume you had a complicated formula, that took a value in say A1, did a whole bunch of stuff to
it ( Technical term there :-> ), and then came up with the answer 'x' in say B1. If you changed
the value in A1 to something else you would get say 'y' in B1, and if you changed it to something
else you would get 'z' in B1. Either way, you have to change the value in A1 every time to get
anything different, and you could only ever have one result at any one time. What the
one-variable data table allows you to do is to leave just one value in A1, but create a list of
potential values for A1 in a table, and then populate that table with the correct results that
would have appeared in B1, assuming each of those values had actually been in A1.

If this even sounds remotely close to what you want, then give it a go. If you feel it might help
and you get stuck, then by all means post back and I can knock up a quick example file and mail it
to you, to show you how it works.
 
Back
Top