Caculations in Tables - Programming Methods

[De Vo]

Hi

I wonder if people can discuss with me "the better technique" on the
way to program the following scenario

I have a table where calculation will be performed

Column Headings of

Employee Name; Gross Pay; Tax / Vat %; Nett Wages;

The Tax / VAT % will be a positive or negative percentage figure
usually -22% or +17.5%

The main part of the problem is how to create the caculation and the
best method (in the long run even if it more complex and will take a
longer time to grasp and fine tune)

I can see that there is the method of placing a dynamic formula in each
Nett Wages cell and then recalculate the table

or

there is the way of reading the data from the cell and dynamically
caculating the Nett Wages for each row and outputting the answer.

Whats is the best method to be using

If it method (b) how do i read data from the cells and anything i need
to watch out for to caculate the data,


Many Thanks

De Vo

 

[Word Heretic]

G'day "De Vo" <[email protected]>,

Duplicate post already answered.


Steve Hudson - Word Heretic Sydney Australia
Word eTutor

steve from wordheretic.com (Email replies require payment)


De Vo reckoned: