Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|