Using If function with text values
The text must be in quotes:
=IF(A10="apples", [5], [2])
--
If this posting was helpful, please click on the Yes button.
Regards,
Michael Arch.
"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!
|