OOo Spreadsheet for Canadian Payroll Tax

[Brian Dolbec]

On Sat, 2005-21-05 at 23:18 -0300, Michael D. Crawford wrote:
> I wrote:
> 
> > Another thing I'd like to know is if there is some way I can calculate a
> > cell's address on the fly rather than hardwiring it.  That way I can key
> > the TD1 exemptions and even the provincial calculations by employee
> > number rather than hardwiring them by employee name as I do now. 
> 
> A little more poking around in OpenOffice's help turned up the 
> appropriately named INDEX function:
> 
> INDEX(reference;row;column;range)
> 
>      A       B
>      ----------
> 1 | 1       4
> 2 | 2       =INDEX(A1:A4;B1)
> 3 | 3	
> 4 | 4	
> 
> The above spreadsheet will result in the value "4" being displayed in 
> cell B2.  Changing B1 to be any value from 1 to 4 will result in the 
> same value being displayed in B2.  Entering 5 will result in "Err:504" 
> being displayed.
> 
> One can assign a name to a range by selecting its cells and then 
> selecting Define Range from the Data menu.  Data->Select Range will 
> select a range by name.
> 
> I'm kind of enjoying finally getting around to getting a clue about 
> spreadsheets!
> 
> Mike

I used the lookup() quite a bit.

About range names.  I found they do not work reliably and I had to
resort to using the actual ranges explicitly.



-- 
Brian Dolbec <brian_dolbec at telus.net>