S
SimiusLive
I've been learning What-If Analysis with data tables. Data tables strike me
as an overcomplicated and contrived method of doing something that could be
done much more easily and naturally without this 'feature'.
In both 1 or 2-variable tables you wind up with a value or values (where
your formula(s) are entered) that seem out-of-place or spurious, formatting
seems less than desirable and requires thought, and you've got to go
through--and remember each time--certain steps to get it all right. (see:
http://office.microsoft.com/en-us/excel/HP100726561033.aspx )
Why not just enter your non-calculated values somewhere, then Auto Fill your
variable(s) and formula(s) however you like, wherever you want, and without
having to remember any wacky procedure?
What am I missing?
as an overcomplicated and contrived method of doing something that could be
done much more easily and naturally without this 'feature'.
In both 1 or 2-variable tables you wind up with a value or values (where
your formula(s) are entered) that seem out-of-place or spurious, formatting
seems less than desirable and requires thought, and you've got to go
through--and remember each time--certain steps to get it all right. (see:
http://office.microsoft.com/en-us/excel/HP100726561033.aspx )
Why not just enter your non-calculated values somewhere, then Auto Fill your
variable(s) and formula(s) however you like, wherever you want, and without
having to remember any wacky procedure?
What am I missing?