Excel 2019 Bible

(singke) #1

Part IV: Managing and Analyzing Data


FIGURE 31.6
The setup for a two-input data table
A formula or
a reference to
a formula

Results of the two-input data
table returned by Excel

Different values
of input cell #1

Different
values of
input cell #2

FIGURE 31.7
This worksheet calculates the net profit from a direct-mail promotion.
Free download pdf