Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excels formuals | Excel Discussion (Misc queries) | |||
Accept Label in Formuals | Excel Discussion (Misc queries) | |||
Formuals | Excel Discussion (Misc queries) | |||
Report with formuals already entered | Setting up and Configuration of Excel | |||
New to Formuals | Excel Worksheet Functions |