$$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.

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

2010-09-30 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 yo