Excel Tip using the Data Table Function

Question:     How do I create a table showing the selling prices of various quantities and cost prices?

Answer:        By using the Data Table option

Why:            Data tables provide a shortcut for calculating multiple results in one operation and a way to view and compare the results of all the different variations together on your worksheet. 

Applies To: Excel 2003, 2007 and 2010

  1. The data in the screen shot below will be used as an example for this tip

 2.         Select cell D4 and type =(B3*B4)+(B5*(B3*B4))

3.            Select the data range D4:J14

4.            Select as below

5.         Then select as per the following screen shot

6.         Select OK

7.         The following data table will be displayed


If you have any suggestions for an Excel Tips & Tricks topic, or you would like help with a particular function, please email [email protected] and yours could be the next Tip of the Week.

Alchemex provides examples of MS Excel procedures for illustration only, without warranty expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The MS Excel procedures on this web site are provided “as is” cannot be guaranteed that they can be used in all situations