View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Cheryle Cheryle is offline
external usenet poster
 
Posts: 3
Default IF, Then formuals

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.