A = abc

[punit83]

Hello

i want a formula for follwing
if in cell A1 i type I = than in B1 answer should be display myself
if in cell A2 i type u = than in B2 answer should be display yourself


Thanks in advance

 

[Fluff]

In B1 put =IF(A1="I","myself","")
& in B2 put =IF(A2="u","yourself","")

 

[punit83]

thanks for reply

and if i want a formula for follwing
if in cell A1 i type I = than in B1 answer should be display myself
if in cell A1 i type u = than in B1 answer should be display yourself

 

[jtakw]

Hi,

I think this is what you mean:

Book1
	A	B
1	i	Myself
2	u	Yourself
3
4	s
5	I	Myself
6	U	Yourself
Sheet31

Cell Formulas
Range	Formula
B1	=IF(A1="I","Myself",IF(A1="U","Yourself",""))

 

[Rick Rothstein]

thanks for reply

and if i want a formula for follwing
if in cell A1 i type I = than in B1 answer should be display myself
if in cell A1 i type u = than in B1 answer should be display yourself

Put this formula in cell B1...

=IF(A1="I","myself",IF(A1="u","yourself",""))

 

[punit83]

Thank you, yeah formula worked for me and yes it is what i wanted.

 

[jtakw]

You're welcome.