I have work an Exel work sheet. Column 1 contains name and column 2 contains a number. I want column 3 to say ‘YES’ if there is a number in column 2 and ‘No’ if there is no number. That’s all. Kindly help me.
thanks guyz i will try it.
Let us know how it goes!
Type the following in the formula bar =IF(A1=number, "Yes", "No") http://spreadsheets.about.com/od/excelfunctions/ss/if_function_sbs.htm
Try with this:
Suppose you have name in A1 and number in A2. Use following formula in column 3=isnumber(A2)
If it returns True, then it is a number otherwise not.
thanks guyz i will try it.
Let us know how it goes!
Type the following in the formula bar
=IF(A1=number, "Yes", "No")
http://spreadsheets.about.com/od/excelfunctions/ss/if_function_sbs.htm
Try with this:
Suppose you have name in A1 and number in A2. Use following formula in column 3=isnumber(A2)
If it returns True, then it is a number otherwise not.