+ Reply to Thread
Results 1 to 3 of 3

Problem with if <= formula not calculating correctly

  1. #1
    Registered User
    Join Date
    07-11-2019
    Location
    Sydney
    MS-Off Ver
    Mac 2008
    Posts
    1

    Question Problem with if <= formula not calculating correctly

    Screen Shot 2019-07-12 at 8.35.00 am.png

    Here is the formula that I am using

    =IF(F4="","",IF(G4<=D4,"Approved","Not Approved"))

    My problem is that the formula is always showing a true value even when it is not. The result in G4 is an absolute value. Not that that should affect but just thought I should say it.

    Any help would be appreciated.

    Thank you

    Paul

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    11,078

    Re: Problem with if <= formula not calculating correctly

    It is difficult to debug from a picture/screenshot. A representative, anonymized sample file would be better.

    That said, I notice that all of the values in column D have a little green triangle indicating some kind of error/warning associated with those cells/values. The first one I think of is "number stored as text". When it comes to "order", a text string is always "larger than" a number, so the text string "185.0" is larger than the number 186.5. The first thing I would do to debug this is to hover over the green triangle and see what error/warning is given. If it is "number stored as text", then the next step is to convert that column to real numbers (some strategies here: https://support.office.com/en-us/art...1-c5bad0f0a885 ).
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    09-25-2016
    Location
    rotterdam
    MS-Off Ver
    2014
    Posts
    4

    Re: Problem with if <= formula not calculating correctly

    may be the change this

    the D4 to E4
    PHP Code: 
    =IF(F4="","",IF(G4<=E4,"Approved","Not Approved")) 
    or
    G4 to F4
    PHP Code: 
    =IF(F4="","",IF(F4<=D4,"Approved","Not Approved")) 

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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