$$Excel-Macros$$ Re: Help require to understand the Formula of the attached sheet

2010-10-01 Thread Shah
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

$$Excel-Macros$$ Re: Help require to understand the Formula of the attached sheet

2010-10-01 Thread anandydr
Dear Mr Hiren Sheth, Perhaps you are refering to {=TABLE(,B3)} listed in the cells. This is not an actual function but a table which is part of excel what if analysis. In Excel 2007 you can go to Data tab What if analysis Table and with older versions this feature is available in Tools menu.