Results 1 to 8 of 8

IF FUNCTION Problem, returning false when number is less than 1000

Threaded View

  1. #1
    Registered User
    Join Date
    09-09-2014
    Location
    London, England
    MS-Off Ver
    Mac Office 2011
    Posts
    3

    Exclamation IF FUNCTION Problem, returning false when number is less than 1000

    Hi everybody

    Usually I'm able to find the solutions to my Excel problems online, but this one is perhaps too specific.

    Here's in the formula:
    =IF(SUM(AC17,AA17,Y17,W17,U17,S17,Q17,O17,M17,K17,I17,G17)=(AF19-AF24),(AF19-AF24),"false")

    So I'm using the formula above to check that the sum of a range of cells equals AF19-AF24.
    If true, then it should return the AF19-AF24 total. If false, it should return error.

    This spreadsheet is not new, I've been using this formula for some time, but only now I've realised that if the AF19-AF24 result is less than 1000, I get a "false", even if the numbers are equal to the SUM range.

    Also, it doesn't matter which cell/column/row I change in the spreadsheet, if the result leads to more than 1000, I get the number I should get from the IF function, but if the result is less than 1000, it gives me a "false", when I should only get a false if the numbers don't match.

    Not sure if I was very clear, please let me know if you can help.

    EDIT/ADDITIONAL INFORMATION

    I've just noticed that I get "false" if the result from the formulas is between -999 and 999.

    I'm attaching here a sample spreadsheet, and the cell with the issue is in yellow.

    Thank you all for your interest in helping!
    Attached Files Attached Files
    Last edited by Lanjal; 01-23-2021 at 05:56 PM. Reason: Additional Information/Attachment

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. IF Function returning false
    By CARDINALKID00 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-04-2020, 06:14 PM
  2. [SOLVED] if fUNCTION - returning false? what is wrong with my criteria
    By rayted in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 07-11-2019, 04:13 PM
  3. [SOLVED] If isnumber search function returning false
    By hawkwolf in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-14-2018, 02:36 PM
  4. Nested If function returning FALSE instead of number
    By erimhast in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-09-2015, 07:47 PM
  5. Replies: 3
    Last Post: 05-28-2015, 01:24 AM
  6. Logical test in IF function returning TRUE when it should be FALSE
    By lvjeff in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-28-2012, 05:13 PM
  7. if function returning false instead of my selection
    By kelleybr in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-27-2006, 03:23 PM

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