Results 1 to 12 of 12

Formula to show a Number 1 or 0 based on dates and numbers.

Threaded View

  1. #1
    Forum Contributor sorensjp's Avatar
    Join Date
    12-23-2015
    Location
    Yokosuka, JP
    MS-Off Ver
    2007 and 2016
    Posts
    196

    Formula to show a Number 1 or 0 based on dates and numbers.

    Hi All,

    I've been unsuccessful creating a formula to show a "1" if True and "0" if False. In cell M39 (Carry/No Carry).

    I would like to show a "1" if cells F18, F39 have a "1" AND the dates in cells G24, L39, H51, H53, & H55 Dates are <= Today().

    Thank you.

    V/r,
    Jim
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula to show number of months (1st and last month inclusive) between 2 dates
    By antmcg12 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 12-17-2020, 04:46 PM
  2. [SOLVED] sum based between dates or week numbers with out effcting current formula (Advanced) ???
    By pmw19800 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-20-2019, 06:10 PM
  3. Formula to show all dates/codes under same Serial Number
    By Redreghan in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-22-2016, 12:24 PM
  4. [SOLVED] formula to sum numbers based off of single or matching dates
    By nicki_rae22 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-21-2014, 01:24 PM
  5. Formula to show number of same numbers (0 or 1) in a row
    By bjn201 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-22-2013, 01:12 PM
  6. [SOLVED] Auto filling dates based on previously entered dates and averaging numbers if dates equal
    By grambograham in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-11-2012, 03:21 PM
  7. Replies: 3
    Last Post: 07-08-2009, 07:05 AM

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