Hi
=if(A10="apples,5,2)

if this helps please click yes, thanks

"IF function with Text" wrote:

I'm trying to use an if function with the logical test being, for example,

=IF(A10=apples, [5], [2])

Is there anyway to utilize the IF funciton using a name or text value for
the logical test?

Thanks!