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.
|