Worlds best microsoft office tutorials content. Find anything about microsoft office tutorials needs on this site.
Calculate Multiple Results By Using. If the above array formula is in cells C1 and C2 in a worksheet then the results would be as follows. So if you wanted to get the Direct or Referral Channels.
Https Encrypted Tbn0 Gstatic Com Images Q Tbn And9gcq6j2iuemjkrdcsnn4dhir6obg Gjyvz Lq77jjl6d9l2s8 6xk Usqp Cau from encrypted-tbn0.gstatic.com
Select the range of cells that contains the formula C2 both the row and column of values C3C5 and D2E2 and the cells in which you want the calculated values D3E5. If you want a separate sheet for each output you can use SheetsAdd and paste into that new sheet. For a two variable data table the copy of the original formula must be entered at the intersection of the row and column input values.
An array formula can perform multiple calculations and then return either a single or multiple result.
So if you wanted to get the Direct or Referral Channels. Data tables are part of a suite of commands that are called what-if analysis tools. At cell B7 type B5. When you use data tables you are doing what-if analysis.