+ 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
    12,488

    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)

Similar Threads

  1. IF + If-And formula not calculating correctly
    By albhatti in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-11-2018, 05:04 PM
  2. Formula not calculating correctly?
    By Dooberry in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-20-2015, 06:38 AM
  3. Problem with sumifs not calculating correctly.
    By graphicjunkie in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 09-30-2015, 01:19 AM
  4. [SOLVED] Formula not calculating correctly
    By ratboyab in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-29-2013, 06:35 PM
  5. Formula not calculating correctly
    By mgfuentes in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-09-2012, 01:21 PM
  6. Formula not calculating correctly
    By Whittle82 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2012, 05:54 PM
  7. Formula Not Calculating Correctly
    By be965 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-23-2007, 03:30 PM

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