Hi Hiren, Well here's the thing. What you have here is a classic one variable data table. Essentially what it is doing is, well lets just say you've done your calculation on something. (which in this case is a payroll calculation in A1 to B11.
Now what a one-variable data table does is it lets you carry out a sensitivity analysis on one of the variables, esentially asking excel to try alternative numbers in your calculation and tabulate the results.. The alternative variable in this case happens to be the number of employees which are being run through your calculation to give the total payroll cost. To MAKE a 1-variable data table: Try the following to understand how its done: 1. Delete everything in cells B15 to B22 2. You've have already typed the number of employees in cells A17 to A22 (This could have been any one of your basic assumptions) 3. Link the cell directly above where you would want your first result to appear to the result in the calculation i.e in cell B16 give the following formula =B11 4. now select the entire area of A16 to A22 and goto data table (You can access the data table menu by pressing Alt then D and then T) 5. now in the Column input link it it cell B3 Riiight, and thats about it. Hope that helps On 30 Sep, 16:17, Hiren Sheth <hiren.sh...@viteos.com> wrote: > Hi Experts, > > Can you please explain formula of cell B17, B18, B19 and B20 of the attached > sheet. > > Thanks > Hiren > This message is for the named person's use only. It may contain confidential, > proprietary or legally privileged information. No > confidentiality or privilege is waived or lost by any mis-transmission. If > you receive this message in error, please immediately > delete it and all copies of it from your system, destroy any hard copies of > it and notify the sender. You must not, directly or > indirectly, use, disclose, distribute, print, or copy any part of this > message if you are not the intended recipient. > Viteos Capital Market Services Ltd.and any of its subsidiaries each reserve > the right to monitor all e-mail communications through > its networks. Any views expressed in this message are those of the individual > sender, except where the message states otherwise and > the sender is authorized to state them to be the views of any such entity > > Book8.xlsx > 13KViewDownload -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
