+ Reply to Thread
Results 1 to 2 of 2

How to work with Null and Not Null Vales

  1. #1
    Registered User
    Join Date
    11-08-2007
    Posts
    18

    How to work with Null and Not Null Vales

    Hello Everyone,

    Please help with the following:

    Column A ReturnDate

    Column B Closed

    I want to run a formula in Column "B" which will find in Column "A"

    Null Value = False
    Not Null Values = True




    This will be imported into a database...its a check box. about 15K rows/records.

    Thanks for your time in advance,

    Frank.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: How to work with Null and Not Null Vales

    Not clear if A are date values or text strings but perhaps

    B1: =A1<>""
    copied down

+ 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