Results 1 to 6 of 6

IF/AND Formula Returning "FALSE" instead of "" (NULL)

Threaded View

  1. #1
    Registered User
    Join Date
    12-21-2011
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2010
    Posts
    19

    IF/AND Formula Returning "FALSE" instead of "" (NULL)

    This is what I am using.
    =IF(C9>=1,IF(D19=MAX(D19:D23),100,""))

    Background of what I want it to do:

    1. C9 is a cell that has to be 100% or greater for this cell to display anything.
    2. D19 is a salesman's % to sales that he currently has as compared to his quota.
    3. D19:D23 is all 5 of the salesman's % to sales and checks to see if it is the MAX of the 5 percentages. If it is the max it displays "100", if not it should display nothing, or NULL.

    However, it is displaying "FALSE" if cell C9 is not greater than or equal to 1. I can't figure it out. Any advice would be appreciated. Thanks!
    Last edited by sourbeer; 03-22-2012 at 11:04 AM. Reason: Solved

Thread Information

Users Browsing this Thread

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

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