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