Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    36

    Unanswered: Help needed with IF statement

    Hi,

    I have two columns (A & B), if column A contains any numbers then I want column B to display 'Yes' and if column A is empty then I would like column B to display 'No'

    Thanks for your help!!

  2. #2
    Join Date
    Mar 2004
    Location
    UK
    Posts
    30
    Try this

    =IF(ISBLANK(A),"no","yes")

    Replace the A with the first cell in column A then copy the forumla down


    Hope this does the job ;o)

  3. #3
    Join Date
    Mar 2004
    Posts
    36
    It works!!

    Thanks for your help

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •