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:confused:


--
MatthewFlinchem
------------------------------------------------------------------------
MatthewFlinchem's Profile: http://www.excelforum.com/member.php...o&userid=34112
View this thread: http://www.excelforum.com/showthread...hreadid=538845

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:confused:


--
MatthewFlinchem
------------------------------------------------------------------------
MatthewFlinchem's Profile:
http://www.excelforum.com/member.php...o&userid=34112
View this thread: http://www.excelforum.com/showthread...hreadid=538845

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

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