Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
adding row to forumla | Excel Discussion (Misc queries) | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |