dpaton05
Well-known Member
- Joined
- Aug 14, 2018
- Messages
- 2,352
- Office Version
- 365
- 2016
- Platform
- Windows
I have the date stored in A1 and a formula in another cell
I want the value in the other cell to be 10 if the date is the on new years day for any year and 200 if it is not. What is wrong with my function?
Excel Formula:
=IF(A1="1/01/*",10,200)
I want the value in the other cell to be 10 if the date is the on new years day for any year and 200 if it is not. What is wrong with my function?