+ Reply to Thread
Results 1 to 4 of 4

If statement with embedded Today() formula

  1. #1
    Registered User
    Join Date
    01-19-2021
    Location
    England
    MS-Off Ver
    MS Office 365
    Posts
    2

    Unhappy If statement with embedded Today() formula

    Hi All,

    I am trying to create an if statement with an embedded date formula in col B, which takes the difference between today's date and another date (F3), where the date in F3 is also derived from a formula.
    If F3 minus today's date is less than 11, the cell should return "AMBER". This is giving me an error, saying there is a problem with this formula. See attached. Just remove the single quotes around the formula in cell B3 to activate it.

    =IF((F3-TODAY())>11)), "AMBER","FALSE")


    Ultimately I want to build a series of embedded if statements where, greater than 10 days to go returns GREEN; between 10 and 0 days to go returns AMBER, and less than 0 days (overdue) returns RED.

    Thanks a lot
    Attached Files Attached Files

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,684

    Re: If statement with embedded Today() formula

    brackets
    =IF(((F3-TODAY())>11), "AMBER","FALSE")
    Last edited by etaf; 01-19-2021 at 08:52 AM.
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    01-19-2021
    Location
    England
    MS-Off Ver
    MS Office 365
    Posts
    2

    Re: If statement with embedded Today() formula

    Much appreciation - it worked a treat

  4. #4
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,684

    Re: If statement with embedded Today() formula

    you are welcome

+ 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. Replies: 5
    Last Post: 09-16-2020, 05:00 PM
  2. [SOLVED] If statement with embedded AND and FIND formula results in #Value
    By amartin575 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-12-2020, 09:28 AM
  3. Embedded IF Than Statement Issue
    By Lousiwu in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-09-2013, 06:26 PM
  4. Excel 2007 : Embedded IF statement issue
    By chrfra in forum Excel General
    Replies: 2
    Last Post: 08-13-2010, 06:38 PM
  5. Greater than Less than in embedded IF statement
    By CMTench in forum Excel General
    Replies: 4
    Last Post: 03-19-2010, 09:50 AM
  6. [SOLVED] Need help with an embedded IF statement
    By Lari in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-17-2006, 12:10 PM
  7. [SOLVED] list embedded in an if statement
    By rk0909 in forum Excel General
    Replies: 0
    Last Post: 03-14-2006, 11:50 AM

Tags for this Thread

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