+ Reply to Thread
Results 1 to 3 of 3

If there is a date then populate text

  1. #1
    Registered User
    Join Date
    03-31-2014
    Location
    Syracuse
    MS-Off Ver
    Excel 2010
    Posts
    31

    If there is a date then populate text

    Hi, I am trying to create a formula where if there is a date in the field it would populate 21.15 next to it, but if there isnt a date for example (1/0/1900) nothing would populate...
    Below is a example... thank you.

    Column J Column K
    2/3/15 21.15
    3/3/16 21.15
    1/0/1900
    2/13/16 21.15
    Attached Images Attached Images

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,531

    Re: If there is a date then populate text

    Try

    =IF(J2<>0,21.15,"")

    copy down

  3. #3
    Registered User
    Join Date
    03-31-2014
    Location
    Syracuse
    MS-Off Ver
    Excel 2010
    Posts
    31

    Re: If there is a date then populate text

    thank you it worked

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Date picker used to populate text box. Date changes back to original value on opening.
    By Stratfordoaks in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-07-2016, 09:42 AM
  2. Replies: 1
    Last Post: 05-26-2014, 03:46 AM
  3. trying to populate rows with text and date...
    By alwaysneedhelp in forum Excel General
    Replies: 6
    Last Post: 05-18-2014, 09:00 AM
  4. [SOLVED] Formula Needed to auto populate current date when text entered into a cell
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-15-2013, 09:50 PM
  5. Replies: 2
    Last Post: 05-30-2013, 12:45 PM
  6. Replies: 1
    Last Post: 09-12-2012, 10:40 AM
  7. Replies: 0
    Last Post: 07-03-2012, 03:52 PM

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