Thread: IF formula misbehaving with determining year of an event
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pierre Pierre is offline
external usenet poster
  
Posts: 193
Default IF formula misbehaving with determining year of an event
In D14 I enter 04/23/2008
in D15 the formula contains
=IF(RIGHT(D14,2)="08","true_value","false_value")

Why is D15 returning "false_value"?
I'd expect "true_value"

Thanks for your help.
Pierre
Reply With QuoteReply With Quote