View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
IF function with Text IF function with Text is offline
external usenet poster
 
Posts: 1
Default Using If function with text values

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!