Need Conditional Formula

  • Thread starter MatthewFlinchem
  • Start date
M

MatthewFlinchem

=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:
 
B

Bob Phillips

=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"
 
R

Ron Coderre

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,
Ro
 
M

MatthewFlinchem

PERFECTO! You all have made my day.........off to brag on my skills
hope you guys dont mind
 
Top