Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Max
 
Posts: n/a
Default

If desired, we could also set-up a 2 variable data table
in the same sheet ..

Experiment with this extension to the set-up ..

Put in say, A19: =C12
(just a link to the output cell of interest)

List some possible inputs for Temp
horizontally into B19:G19
say, the values: 10, 11, 12, ... 15
(for the row input cell)

and some possible inputs for Alt
vertically down in A20:A30
say: 1000, 1100, .. 2000
(these will be for the column input cell)

Select A19:G30

Click Data Table
For "Row input cell", put: B12
For "Column input cell", put: A12
Click OK

(Mask A19 by formatting the font as white)

The above will drive out the table below in A19:G30:

974 10 11 12 13 14 15
1000 765 770 777 783 789 795
1100 772 778 784 791 797 803
1200 779 786 792 799 805 811
1300 787 793 800 806 813 819
1400 795 801 808 814 821 827
1500 802 809 815 822 829 835
1600 810 816 823 830 836 843
1700 817 824 831 838 844 851
1800 825 832 839 845 852 859
1900 832 839 846 853 860 867
2000 840 847 854 861 868 875

You could also simply overwrite
the Temp and/or Alt variable values
listed in either B19:G19 and A20:A30
with other possible input values, and
the intersecting values within (B20:G30)
will be recalculated accordingly

--
Note: The formula: {=TABLE(B12,A12)} will appear in B20:G30
Albeit it looks like an array formula, it cannot just
be entered as such. The construct must be done/invoked
via the Data Table steps outlined

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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



All times are GMT +1. The time now is 10:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"