Results 1 to 7 of 7

Two IF Statements in One Cell Returning Incorrect Results

Threaded View

  1. #1
    Registered User
    Join Date
    03-31-2011
    Location
    U.P., MI
    MS-Off Ver
    Excel 2003
    Posts
    3

    Two IF Statements in One Cell Returning Incorrect Results

    Hello,

    I am trying to compare two columns, each with it's own condition and rank then for sorting later. Below is my statement:

    =IF(B4<$B$2,IF(C4<$C$2,0,1))
    The issue am having is that in some of the destination cells it gives me a "FALSE" result while in others, it outputs either "1" or "0", which is what I would like. I have tried modifying the statement after reading similar posts but I have been unsuccessful. I changed the reference cells to numbers, that didn't help ().

    Any help is greatly appreciated!

    P.S. I have attached a file
    Attached Files Attached Files
    Last edited by Shiks; 03-31-2011 at 10:13 PM. Reason: Problem solved :)

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