Using If function with text values

  • Thread starter Thread starter IF function with Text
  • Start date Start date
I

IF function with Text

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!
 
Text string should always be inside double quotes

=IF(A10="apples",5,2)

If this post helps click Yes
 
OPPs I missed a quote

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


Eduardo said:
Hi
=if(A10="apples,5,2)

if this helps please click yes, thanks

IF function with Text said:
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!
Click to expand...
Click to expand...
 
Back
Top