View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Can'tExcel Can'tExcel is offline
external usenet poster
 
Posts: 1
Default If - Function in Excel 2003: HELP!

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!