A formula need on IF

[ahamed]

Hi every one

Can any one help me on constructing a formula to find follow;


If Cell A1 contain =

1. Telephone (text) or,
2. Blank ("")

Return (in A2) as 1 (if true), 2 (FALSE)

(please consider, that I need to distinguish only Telephone & blanks (empty) cell from all other text that could be in A1


Thank you in advance

 

[Peter_SSs]

Is this what you mean?

=2-OR(A1={"","Telephone"})

 

[marka87uk]

I would do this...

=IF(A1="Telephone",1,IF(A1="",1,2))

 

[ahamed]

Dear Peter

Exactly, thank you very much for kind help

 

[anandvarma]

try this

Excel Workbook
	A	B
1	telephone	1
Sheet2

 

[Peter_SSs]

Dear Peter

Exactly, thank you very much for kind help

No problem. Thanks for the feedback.

 

[ahamed]

Dear Marka

Thank you, this too working,,