Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create formula
How do I create this Formula in cell If K6=4 then E6=1 and IF K6=3 then
E6=2 and IF K6=2 then E6=2 and IF K6=1 then E6=4? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create formula
If K6 can only contain 1,2,3 or 4, then maybe this?
E6: =5-K6 Is that something you can work with? *********** Regards, Ron XL2002, WinXP "EOB" wrote: How do I create this Formula in cell If K6=4 then E6=1 and IF K6=3 then E6=2 and IF K6=2 then E6=2 and IF K6=1 then E6=4? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create formula
On Fri, 22 Sep 2006 18:41:02 -0700, EOB wrote:
How do I create this Formula in cell If K6=4 then E6=1 and IF K6=3 then E6=2 and IF K6=2 then E6=2 and IF K6=1 then E6=4? There are many ways. Here's one: E6: =IF(ISERR(CHOOSE(K6,4,2,2,1)),"K6 out of range",CHOOSE(K6,4,2,2,1)) Here's another: E6: =IF(K6=4,1,IF(OR(K6={3,2}),2,IF(K6=1,4,"K6 out of range"))) --ron |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create formula
On Fri, 22 Sep 2006 18:48:01 -0700, Ron Coderre
wrote: If K6 can only contain 1,2,3 or 4, then maybe this? E6: =5-K6 Is that something you can work with? *********** Regards, Ron XL2002, WinXP "EOB" wrote: How do I create this Formula in cell If K6=4 then E6=1 and IF K6=3 then E6=2 and IF K6=2 then E6=2 and IF K6=1 then E6=4? But E6 = 2 when K6 = 2 or 3 --ron |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create formula
Here's one idea as an array formula:
=IF(OR(K6={1,2,3,4}),MOD(226, K6 + 5),#N/A) -- HTH :) Dana DeLouis Windows XP & Office 2003 "EOB" wrote in message ... How do I create this Formula in cell If K6=4 then E6=1 and IF K6=3 then E6=2 and IF K6=2 then E6=2 and IF K6=1 then E6=4? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create formula
"EOB" skrev i en meddelelse
... How do I create this Formula in cell If K6=4 then E6=1 and IF K6=3 then E6=2 and IF K6=2 then E6=2 and IF K6=1 then E6=4? Another option: In E6: =INDEX({4,2,2,1},MATCH(K6,{1,2,3,4},0)) -- Best regards Leo Heuser Followup to newsgroup only please. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create an increase or decrease formula with zero % | Excel Worksheet Functions | |||
How do I create a formula by percentage within a formula? | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
How do I create a 26 'tier' IF formula? | Excel Discussion (Misc queries) | |||
How to create specific formula | Excel Worksheet Functions |