You could also use:

C1 = Salary amount

A1 = 25%
A2 = 20%
A3 = 15%
A4 = 10%

B1 = 0
B2 = 300
B3 = 500
B4 = 600

=C1*INDEX(A1:A4,MATCH(C1,B1:B4))

Tyro

"Can'tExcel" wrote in message
...
I'm a novice to Excel 2003, I know what I want the 'if function" to do,
but
I'm not able to input the data into the function window. I have a project
that I'm working on that have the following data:
one column of % values 25%, 20%, 15%, and 10% with corresponding dollar
figures in the next column $0 - $299.99; $300.00 - 499.99; $500.00 -
599.99;
$600+.
What I want to do with the if-function is that in one cell every time I
put
in a salary amount than the function should chose the correct % amount.
For
instance, If a salary is $350.00 than the if-function should select 20% in
one cell and then I need the next cell to perform the calculation of $350
x
20% .

Is there anybody that call help me!