Club CDFreaks - Knowledge is Power - View Single Post - if-then-else construction in Excel formula

solskjaer · 31-10-2002

=ALS(EN(A1=1;B1=1);1;ALS(EN(A1=2;B1=3);2))
With English version of Excel:
als = if
en =and

[edit]
This is an English forum, no Dutch allowed!
Edited it for you this time.
[/edit]

31-10-2002	#3 (permalink)
solskjaer New on Forum Join Date: Oct 2002 Posts: 10	Possible solution =ALS(EN(A1=1;B1=1);1;ALS(EN(A1=2;B1=3);2)) With English version of Excel: als = if en =and [edit] This is an English forum, no Dutch allowed! Edited it for you this time. [/edit] Last edited by Da_Taxman; 31-10-2002 at 18:27.