Here is what I am trying to do:
1) A B C D E F G H I J K
2) Day x 1 x X 8 X 45.00 X X 360.00

The formula I have that I am using right now is =IF(C2=0,"",(H2*F2))

I want to make A2 a drop down that says either Days or Weeks
If A2=Days then I want it to do (H2*F2)
If A2=Weeks then I want it to do (H2*F2)*5

I have tried all the if then statements I know and I either come up with "FALSE" or it will accept my formual but give me 0.00 in K2

Here is one the formulas I have tried. I have tried quite a few different ways.
=IF(A2=Days,""(H2*F2),IF(A2=Weeks,""(H2*F2)*5))

Thanks for any help you can give me.

Hi Cheryle
=IF(A2="Days",(H2*F2),IF(A2="Weeks";(H2*F2)*5;0))

HTH
Cordially
Pascal

"Cheryle" a écrit dans le message de
...
Here is what I am trying to do:
1) A B C D E F G H I J K
2) Day x 1 x X 8 X 45.00 X X 360.00

The formula I have that I am using right now is =IF(C2=0,"",(H2*F2))

I want to make A2 a drop down that says either Days or Weeks
If A2=Days then I want it to do (H2*F2)
If A2=Weeks then I want it to do (H2*F2)*5

I have tried all the if then statements I know and I either come up with
"FALSE" or it will accept my formual but give me 0.00 in K2

Here is one the formulas I have tried. I have tried quite a few different
ways.
=IF(A2=Days,""(H2*F2),IF(A2=Weeks,""(H2*F2)*5))

Thanks for any help you can give me.