Results 1 to 5 of 5

Formula not working when criteria cell is populated with a formula

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-04-2016
    Location
    dallas tx
    MS-Off Ver
    365 (15.0.5501.1000)
    Posts
    539

    Formula not working when criteria cell is populated with a formula

    I have a simple logic statement that checks the time and if it is less than a set time it is to display a 1. If the time is greater then display a 2. It works great when I type the times out but when I populate the question cell with Now() formula it no longer works.
    How do you get the logic test to look at the value of the cell and not return a "negative" when it sees a formula?
    Attached Files Attached Files
    Last edited by chriswrcg; 05-06-2023 at 10:17 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] List populated by criteria not working
    By chriswrcg in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-08-2022, 12:10 PM
  2. [SOLVED] if formula not working when cells populated with formulas
    By chriswrcg in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-14-2022, 08:36 AM
  3. [SOLVED] Formula not working correctly when a cell is being populated by another formula
    By gazzak in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-23-2021, 11:10 AM
  4. Formula to get value of last populated cell and +1 to that value?
    By WesD in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-12-2019, 05:16 PM
  5. Replies: 3
    Last Post: 03-09-2019, 12:04 PM
  6. Formula not working with multiple cell criteria
    By pentekno2 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-26-2014, 12:32 PM
  7. Formula to search and return cell based on criteria not working
    By DifferentFrogs in forum Excel General
    Replies: 9
    Last Post: 03-21-2012, 10:48 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