PeterGeeJA
New Member
- Joined
- Mar 25, 2024
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
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.
=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.