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

[sourbeer]

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!

[Bob Phillips]

Add another ""

=IF(C9>=1,IF(D19=MAX(D19:D23),100,""),"")

[sourbeer]

Why did that work????

I am still trying to wrap my head around these formulas. Why did that work?

[BarryTSL]

=IF(C9>=1,IF(D19=MAX(D19:D23),100,""),"") are you missing the last set of ( ,"" ) from your formula ?

[BarryTSL]

The second if statement is correct as it has a logical test (D19=MAX(D19:D23), value if true (100) and value if false ("") but the first if statement has
logical test (C9>=1), value if true (IF(D19=MAX(D19:D23),100,"") but no value if false ! and so the " FALSE" is returned.

[sourbeer]

Ok, I see. I always forget that each IF statement needs its TRUE and FALSE parameters set. Thanks!