Creating an Expense Form

[NRI]

I am trying to create an expense form in excel for mac 2008, a few of the columns I want to work automatically - I have seen what I am trying to achieve done however am not sure how to recreate it.

1. in a column I want to type either a Y or N character and depending on which character it is eg. N - then in a seperate column an amount form yet another seprate column on the same line will appear?

2. Automatically work out the 10% GST component on amounts entered and reproduse in a seprate column?

3. Also to continually add the values as they are entered in a column and give totals in another column?

Cheers for any help...

[royUK]

1. I would think VLOOKUP
2. Assume the Gross in A1, in B1 =A1/11 to get the tax element
3. Not sure what totals you want, but see if Macs have a Table feature similar to Windows operated Office