Expert: Richard Stephens - 6/21/2008

Question
I'm

Cell A2 contains number days worked per year (ie. 241)
Cell B2 contains number of hours worked per day(ie. 4)
Cell C2 contains years of service (ie. 17)
Cell D2 contains an hourly wage (ie. 12.69)

In cell E2 I would like to obtain the follow result:
  If  A2>25, then multiple cell D2 times 1.15
  If  A2>20, then multiple cell D2 times 1.10
  If  A2>15, then multiple cell D2 times 1.05
  If  A2>=0, then multiple cell D2 times 1.0

In cell F2, I would like =PRODUCT(A2,B2,E2)

First, how can I format E2 so that it performs the PRODUCT function within the IF function?

Second, how do I get F2 to see the value of E2 as a numerical value and not a formula?

Answer
Tim

I am a little confused with the question.  You don't mention product inthe E2 cell, you are looking for a multiplication option using the if statement.  

The product in F2 will automatically use the figure generated by the if function in E2.

Have a look at this quick sheet I created here.

www.pcexperthelp.com/answers/tim.xls