software

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

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.laanemetslt;atgt;tarkon.ee )
quot;allertonagainquot; gt; wrote in message
...
gt; hi trying to wright a if formula eg if b1=1 then (c2*d2 e2) if b1=2 then
gt; (c2*d2)
gt; if b1=3 then (c2*d2-e2) i need to have 5 if test just like the above

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: www.excelforum.com/member.php...oamp;userid=30736
View this thread: www.excelforum.com/showthread...hreadid=511623