Results 1 to 4 of 4

IF Statement Returns False When True On Certain Numbers

Threaded View

  1. #1
    Registered User
    Join Date
    11-26-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2003
    Posts
    8

    IF Statement Returns False When True On Certain Numbers

    First time post!

    I am subtracting one cell from another and putting the answer in a separate cell. Then using the answer in another I use a formula to see if the answer equals a certain value.

    Eg A3-A1. Answer goes in B1. Then in C1 formula IF(B1=0.2,"TRUE","FALSE")

    For some reason certain values do not work and I am completely lost for why this is happening! I use excel regularly but am no expert but this has completely stumped me. I've a horrible feeling I may look very stupid over this! Ha.

    I have attached an excel sheet in case I have not explained this very well! All three examples should show TRUE but only the last one is!!

    Thanks in advance!

    Paul
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. lookup exact match returns TRUE or FALSE
    By quade_1 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-05-2016, 02:21 AM
  2. IF STATEMENT returns False, even though the results are true
    By Biolu527 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-28-2013, 11:21 AM
  3. Replies: 5
    Last Post: 12-09-2012, 11:04 PM
  4. InStr function returns pseudo True/False?
    By GCW esq in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-04-2012, 08:00 AM
  5. Function that compares dates and returns TRUE or FALSE
    By Emily in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-25-2006, 04: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