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!
Bookmarks