If you only have those 2 different variables:

=IF(B1=10,"AB",IF(B1=11,"xy",""))

If you have many variables then you should create a table and use a lookup
formula. See this:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


"Sanjiv" wrote in message
...
I have :

A B
1 10
2
3 11
4 11
5 10

I want to write a formula in Col A that
If B=10 then in col A1= have a value say "AB"
if B=11 then in col A1= have a value say "xy"
else
Col A1=blank

Kindly help and many thanks for that.