| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditions
First sorry for my English.
May I know how to create a conditional function for this reason. I create a function in A1 cell using data validation function list option. After that I can select in A1 cell as 2000, 2001, 2002, 2003 like that. I typed in I column as I3=1 , I4=2 , I5=3 Now I want to prepare a condition in A3 cell If A3=2000 A3 = I3 and If A3=2001 A3 = I4 and If A3=2002 A3 = I4 and If A3=2003 A3 = I5 like that. Please help me to create this condition. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditions
Hi,
Maybe this =CHOOSE(A1-1999,I3,I4,I5) Mike "Lahi" wrote: First sorry for my English. May I know how to create a conditional function for this reason. I create a function in A1 cell using data validation function list option. After that I can select in A1 cell as 2000, 2001, 2002, 2003 like that. I typed in I column as I3=1 , I4=2 , I5=3 Now I want to prepare a condition in A3 cell If A3=2000 A3 = I3 and If A3=2001 A3 = I4 and If A3=2002 A3 = I4 and If A3=2003 A3 = I5 like that. Please help me to create this condition. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditions
Thank you very much for your kind help. I found this method. I used If
condition. =IF($A$1=2009,I3,IF($A$1=2010,J3,IF($A$1=2011,K3,I F($A$1=2012,L3)))) like that. "Mike H" wrote: Hi, Maybe this =CHOOSE(A1-1999,I3,I4,I5) Mike "Lahi" wrote: First sorry for my English. May I know how to create a conditional function for this reason. I create a function in A1 cell using data validation function list option. After that I can select in A1 cell as 2000, 2001, 2002, 2003 like that. I typed in I column as I3=1 , I4=2 , I5=3 Now I want to prepare a condition in A3 cell If A3=2000 A3 = I3 and If A3=2001 A3 = I4 and If A3=2002 A3 = I4 and If A3=2003 A3 = I5 like that. Please help me to create this condition. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif Conditions - Use of conditions that vary by cell value | Excel Discussion (Misc queries) | |||
| 2 Conditions + Sum of a colum matching those conditions | Excel Worksheet Functions | |||
| CF with 4 conditions | Excel Worksheet Functions | |||
| shade cells based on conditions - i have more than 3 conditions | Excel Worksheet Functions | |||
| How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions | |||
Linear Mode
