| Home |
| Search |
| Today's Posts |
|
#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. |
| 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 | |||
Threaded Mode
