IF, COUNTIF

[Harvey Waxman]

Can someone explain why these two expressions differ referring to the value 5?

IF(A2:A10<5 etc. ) but
COUNTIF(A2:A10,"<5") requires a comma and quotes

Wouldn't it make sense for them to be the same?

Just wondering.

 

[CyberTaz]

For us it would seem to make sense, but for the computer not so much

My understanding is that in the IF statement the <5 is a Comparison
Operation which is a part of the 1st Function Argument whereas in the
COUNTIF it is a Criteria Reference supplied as the 2nd independent Function
Argument. If it stood alone as simply <5 it would have no logical meaning.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[Harvey Waxman]

Let's vote on it

Thanks

For us it would seem to make sense, but for the computer not so much

My understanding is that in the IF statement the <5 is a Comparison
Operation which is a part of the 1st Function Argument whereas in the
COUNTIF it is a Criteria Reference supplied as the 2nd independent Function
Argument. If it stood alone as simply <5 it would have no logical meaning.

Regards |:>)
Bob Jones
[MVP] Office:Mac