Year Formula Partially Works

[PeterGeeJA]

By default, the formula below (in cell C8) returns the current year.

=IF(OR(C8="[Select Month]",C8=""),"",IF(D12=TEXT(TODAY(),"yyyy"),"",IF(D12<>"",D12,TEXT(TODAY(),"yyyy"))))

1. It works OK for all the conditions EXCEPT one.

2. If the value in cell C8 is equal to the value in cell D12, then cell C8 should not show a value, otherwise the value of cell D12 should be shown.

3. However, When C8 = C12, the value is also shown C8, which should not be.


Please help. Thanks.

 

[RoryA]

Add it to the OR part at the start:

=IF(OR(C8="[Select Month]",C8="",C8=D12),"",IF(D12=TEXT(TODAY(),"yyyy"),"",IF(D12<>"",D12,TEXT(TODAY(),"yyyy"))))

 

[PeterGeeJA]

Thanks for your help.

The solution found was modifying the formula to, YEAR(TODAY()), making it numeric to match the numeric value entered in D12.

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Year Formula Partially Works
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[PeterGeeJA]

Ok, thanks for the reminder.