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