Can you help me with setting up my Excel sheet?

Kakashe September 25, 2011

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.

  1. Saa Zagros
    September 26, 2011 at 12:41 pm

    thanks guyz i will try it.

    • Tina
      September 26, 2011 at 8:21 pm

      Let us know how it goes!

  2. Anonymous
    September 26, 2011 at 11:07 am

    Type the following in the formula bar 
    =IF(A1=number, "Yes", "No") 
    http://spreadsheets.about.com/od/excelfunctions/ss/if_function_sbs.htm

  3. Vimal Kaul
    September 25, 2011 at 9:01 pm

    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.