Using If function with text values

  • Thread starter IF function with Text
  • 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!
 
J

Jacob Skaria

Text string should always be inside double quotes

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

If this post helps click Yes
 
E

Eduardo

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format within a Function 1
Ms Excel Multiple Logical Test Function 0
Return result of IF logical test in a different cell 1
Logical formatting for multiple values 1
function to populate a cell where formula is NOT located 6
Will sumproduct work? 1
Using a function to count cells based on multiple criteria 1
IF - AND Function 3

Top