G
Guest
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.
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.