Automating a Worksheet
in [Functions]
|
From: hankb on 23 Mar 2010 18:25 Max, Thanks for your persistence. I got it to work just fine. Really do appreciate your help. hankb "Max" wrote: > That's the underlying principle and it should work fine. As long as o/p F30 > varies dependent on i/p A1, no matter how complex the relationship in-between > is, Data > Table will do it for you. Exactly what kind of errors were you > getting? I recollect only an implicit subtlety in that the data > table needs > to be set-up on the *same sheet* as the source o/p formula and/or source i/p. > If you need to reflect the results elsewhere, just use simple links pointing > to the relevant cells in the table. Give it another go? > -- > Max > Singapore > --- > "hankb" wrote: > > Thank you Max. Your solution assumes a direct mathematical relationship > > between the input A1 and the output F30. There isn't. It is a long > > cumbersome set of relationships and functions to derive the output F30. > > These involve additions, subtractions, multiplications by constants etc. > > You are right, in that I want to achieve one variable input, with a > > corresponding set of resultant outputs. > > hankb >
From: Max on 23 Mar 2010 18:48
Glad to hear. Do take a moment to hit the YES below -- Max Singapore --- "hankb" wrote: > Max, > Thanks for your persistence. I got it to work just fine. Really do > appreciate your help. > hankb |