Readers like you help support MUO. When you make a purchase using links on our site, we may earn an affiliate commission. Read More.

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.

Saa Zagros
2011-09-26 12:41:00
thanks guyz i will try it.
Tina
2011-09-26 20:21:00
Let us know how it goes!
2011-09-26 11:07:00
Type the following in the formula bar =IF(A1=number, "Yes", "No") http://spreadsheets.about.com/od/excelfunctions/ss/if_function_sbs.htm
MAKEUSEOF VIDEO OF THE DAY
SCROLL TO CONTINUE WITH CONTENT
Vimal Kaul
2011-09-25 21:01:00
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.