to large if formula
 

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

to large if formula
 

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)


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"allertonagain" wrote in message
...
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

to large if formula
 

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

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

Remember to close off al the brackets at the end

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=511623