to large if formula

A

allertonagain

hi trying to wright a if formula eg if b1=1 then (c2*d2+e2) if b1=2 then
(c2*d2)
if b1=3 then (c2*d2-e2) i need to have 5 if test just like the above
 
A

Arvi Laanemets

Hi

=CHOOSE(B1,C2*D2+E2,C2*D2,C2*D2-E2,...)
or (when the multiply part of formula remains same)
=C2*D2+CHOOSE(B1,E2,0,-E2,...)

When the added value in formula changes as E2,0,-E2,-2*E2,-3*E2, then the
formula will be simpler:
=C2*D2+E2*(2-B1)
 
E

EdMac

Generally if you follow the logic below you will find it easy

=If(condition1,Do this,If(condition2,do that,if(condition3,D
another,If(......

Remember to close off al the brackets at the end

E
 
Top