+ Reply to Thread
Results 1 to 3 of 3

IF issues

  1. #1
    Registered User
    Join Date
    08-04-2009
    Location
    Oxford, England
    MS-Off Ver
    Excel 2010
    Posts
    47

    IF issues

    Hi All

    I'm having a bit of a problem with a formula calculating if a date is greater than =today()+2 then it should return as within the agreed time but if it's below that time it is about to breach it's agreed times

    Could it have anything to do with the date/time format setting of the =today() function?

    For some reason the formula shows everything as either within the agreed time or breached it's agreed time

    I've attached the example to show you what I mean and highlighted the fields that should show the information

    Any advise will be much appreciate

    Thanks in Advance

    Dan
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: IF issues

    Hi, just an attempt

    =IF(AI2+0>$AZ$1, "within SLA","about to breach")
    Maybe it helps

    Regards

  3. #3
    Registered User
    Join Date
    08-04-2009
    Location
    Oxford, England
    MS-Off Ver
    Excel 2010
    Posts
    47

    Re: IF issues

    Canapone, Thank you very much for your help on this

    This has made my life considerably easier now

    Thanks again

    Dan

+ 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