In A1: =IF(B1=1,"B1 is 1","")
In A2, =IF(B1=2,"B1 is 2","")
best I can do with the limited info you gave
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Ajit Munj" wrote in message
...
I have entered 2 formulae with if function in cell a2 and a3. I want excel
to
execute formula in a2 if condition 1 satisfies else execute formula in a1.
can I do so? how?
thanx
ajit
--
Knowldege is Power