| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF formula misbehaving with determining year of an event
Because you are trying to use the RIGHT function (which is designed to
manipulate a string) with a value; in Excel 4/23/08 is equal to 39561 because it is counting the number of days since 1/1/1900. Try using YEAR instead of RIGHT: =IF(YEAR(D14)=2008,true,false) On Apr 24, 10:01 am, Pierre wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF formula misbehaving with determining year of an event
Reitanos,
Thank you for clarifying. Works fine now. Pierre On Apr 24, 9:12*am, Reitanos wrote: Because you are trying to use the RIGHT function (which is designed to manipulate a string) with a value; in Excel 4/23/08 is equal to 39561 because it is counting the number of days since 1/1/1900. Try using YEAR instead of RIGHT: =IF(YEAR(D14)=2008,true,false) On Apr 24, 10:01 am, Pierre wrote: 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- Hide quoted text - - Show quoted text - |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Misbehaving Tab | Excel Worksheet Functions | |||
| need formula 4 %change on both neg and pos movemnt year to year co | Excel Discussion (Misc queries) | |||
| Variable determining formula | Excel Discussion (Misc queries) | |||
| Formula for determining sales commission | Excel Worksheet Functions | |||
| need help with determining a formula | Excel Worksheet Functions | |||
Linear Mode
