Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() =IF(E2=1,D2/70),IF(E2=2,D2/200),IF(E2=3,D2/250),0 I am trying to use the formula above and have a few more "if's" to add but this is not working. I have tried multiple things including "AND". Any assistance would really make my day! Thanks, Matt ![]() -- MatthewFlinchem ------------------------------------------------------------------------ MatthewFlinchem's Profile: http://www.excelforum.com/member.php...o&userid=34112 View this thread: http://www.excelforum.com/showthread...hreadid=538845 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Sum Formula? | Excel Discussion (Misc queries) | |||
need a conditional formula to generate numbers divisible by 4 between a given starting no. & end No. | Excel Worksheet Functions | |||
Conditional formatting...cont. from 9/25 | Excel Discussion (Misc queries) | |||
Conditional Formatting formula not acceptable? | Excel Discussion (Misc queries) | |||
Formula Dependant Conditional Formatting | Excel Discussion (Misc queries) |