IF formula misbehaving with determining year of an event
You could try:
=IF(TEXT(A5,"yy")="08","true_value","false_value")
HTH,
Paul
--
"Pierre" wrote in message
...
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
|