I put salary in Column A, I hope when I input someone's salary in column A,
in column B the corresponding tax would be computed automatically. And I am
not sure I need how many Rows there are in my worksheet. It means I can
input salary in any row in column A and the tax would be computed in column
B.

Take a look he

http://www.mcgimpsey.com/excel/variablerate.html

In article ,
"hui" wrote:

I put salary in Column A, I hope when I input someone's salary in column A,
in column B the corresponding tax would be computed automatically. And I am
not sure I need how many Rows there are in my worksheet. It means I can
input salary in any row in column A and the tax would be computed in column
B.

May I do it in Excel worksheet?

thank u in advance

hui

I means I can put any function in some Column so that when the corresponding
column data changes, the column would automaticall exceute column function.
not only about tax.

such as
I put function "=year(now)-left(a1,4)" in Col B, it would work in whole
Column
Col:A Col:B
1 1980-9-1 27
2 1983-11-2 24
.........................
X Row (I am not sure where it is)
X 1979-8-2 28
........................

hui

Assuming your A1 is a real date

B1 =IF(A1="","",YEAR(TODAY())-YEAR(A1))

Format cell as General
Copy all the way down as far as needed


"hui" wrote:

I put salary in Column A, I hope when I input someone's salary in column A,
in column B the corresponding tax would be computed automatically. And I am
not sure I need how many Rows there are in my worksheet. It means I can
input salary in any row in column A and the tax would be computed in column
B.

May I do it in Excel worksheet?

thank u in advance

hui