Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Conditional Formula
=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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Conditional Formula
=IF(E2=1,D2/70,IF(E2=2,D2/200,IF(E2=3,D2/250,0)))
the rest would depend upon how you want to resolve it. For instance if E2=4 you want D2/70, you could use =IF(OR(E2=1,E2=4),D2/70,IF(E2=2,D2/200,IF(E2=3,D2/250,0))) if it has another value you need =IF(E2=1,D2/70,IF(E2=2,D2/200,IF(E2=3,D2/250,IF(E2=4,D2/300,0)))) However this soon runs out, too many nested functions, but there are other possible solutions, such as =CHOOSE(E2,70,200,250,300,350,400,450)*D2 -- HTH Bob Phillips (remove xxx from email address if mailing direct) "MatthewFlinchem" <MatthewFlinchem.27aaym_1146748209.5783@excelfor um-nospam.com wrote in message news:MatthewFlinchem.27aaym_1146748209.5783@excelf orum-nospam.com... =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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Conditional Formula
Try something like this: =D2/CHOOSE(E2,70,200,250) That will account for E2 values of 1,2, or 3. You'll need to enter a distinct value for each possible value in E2. Check Excel Help for more specifics. Does that help? Regards, Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=538845 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Conditional Formula
PERFECTO! You all have made my day.........off to brag on my skills, hope you guys dont mind. -- MatthewFlinchem ------------------------------------------------------------------------ MatthewFlinchem's Profile: http://www.excelforum.com/member.php...o&userid=34112 View this thread: http://www.excelforum.com/showthread...hreadid=538845 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |