+ Reply to Thread
Results 1 to 21 of 21

Check to see if a cell is populated

  1. #1
    Registered User
    Join Date
    08-19-2005
    Posts
    1

    Lightbulb Check to see if a cell is populated

    I know this is very easy I just can't think right now. How do I check if a cell is populated and enter one specific string if it is. Ex:

    |A ___________|B_______________|
    |____________|_________________|
    |Example Data | EBCDIC__________|
    |No Data Here | This would be blank |

    Sorry bout the example being crude but I think it works. I need column B to populate with "EBCDIC" when there is data entered into column A. Thnx for any input.

  2. #2
    Blue Hornet
    Guest

    Re: Check to see if a cell is populated

    =IF( ISBLANK( A2), "A2 is blank", "A2 is not blank")

    Chris


  3. #3
    Blue Hornet
    Guest

    Re: Check to see if a cell is populated

    =IF( ISBLANK( A2), "A2 is blank", "A2 is not blank")

    Chris


  4. #4
    Blue Hornet
    Guest

    Re: Check to see if a cell is populated

    =IF( ISBLANK( A2), "A2 is blank", "A2 is not blank")

    Chris


  5. #5
    Blue Hornet
    Guest

    Re: Check to see if a cell is populated

    =IF( ISBLANK( A2), "A2 is blank", "A2 is not blank")

    Chris


  6. #6
    Blue Hornet
    Guest

    Re: Check to see if a cell is populated

    =IF( ISBLANK( A2), "A2 is blank", "A2 is not blank")

    Chris


  7. #7
    Blue Hornet
    Guest

    Re: Check to see if a cell is populated

    =IF( ISBLANK( A2), "A2 is blank", "A2 is not blank")

    Chris


  8. #8
    Blue Hornet
    Guest

    Re: Check to see if a cell is populated

    =IF( ISBLANK( A2), "A2 is blank", "A2 is not blank")

    Chris


  9. #9
    Blue Hornet
    Guest

    Re: Check to see if a cell is populated

    =IF( ISBLANK( A2), "A2 is blank", "A2 is not blank")

    Chris


  10. #10
    Blue Hornet
    Guest

    Re: Check to see if a cell is populated

    =IF( ISBLANK( A2), "A2 is blank", "A2 is not blank")

    Chris


  11. #11
    Blue Hornet
    Guest

    Re: Check to see if a cell is populated

    =IF( ISBLANK( A2), "A2 is blank", "A2 is not blank")

    Chris


  12. #12
    Blue Hornet
    Guest

    Re: Check to see if a cell is populated

    =IF( ISBLANK( A2), "A2 is blank", "A2 is not blank")

    Chris


  13. #13
    Blue Hornet
    Guest

    Re: Check to see if a cell is populated

    =IF( ISBLANK( A2), "A2 is blank", "A2 is not blank")

    Chris


  14. #14
    Blue Hornet
    Guest

    Re: Check to see if a cell is populated

    =IF( ISBLANK( A2), "A2 is blank", "A2 is not blank")

    Chris


  15. #15
    Blue Hornet
    Guest

    Re: Check to see if a cell is populated

    =IF( ISBLANK( A2), "A2 is blank", "A2 is not blank")

    Chris


  16. #16
    Blue Hornet
    Guest

    Re: Check to see if a cell is populated

    =IF( ISBLANK( A2), "A2 is blank", "A2 is not blank")

    Chris


  17. #17
    Blue Hornet
    Guest

    Re: Check to see if a cell is populated

    =IF( ISBLANK( A2), "A2 is blank", "A2 is not blank")

    Chris


  18. #18
    Blue Hornet
    Guest

    Re: Check to see if a cell is populated

    =IF( ISBLANK( A2), "A2 is blank", "A2 is not blank")

    Chris


  19. #19
    Blue Hornet
    Guest

    Re: Check to see if a cell is populated

    =IF( ISBLANK( A2), "A2 is blank", "A2 is not blank")

    Chris


  20. #20
    Blue Hornet
    Guest

    Re: Check to see if a cell is populated

    =IF( ISBLANK( A2), "A2 is blank", "A2 is not blank")

    Chris


  21. #21
    Blue Hornet
    Guest

    Re: Check to see if a cell is populated

    =IF( ISBLANK( A2), "A2 is blank", "A2 is not blank")

    Chris


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1