Forum Discussion
naythor
May 01, 2021Copper Contributor
Excel IF function
Hello, I'm working on a budget spreadsheet. Cell B1 is a date. I need to output what's in cell D15 if the month in cell B1 is an even month otherwise output NPD.
=IF(B1(month)=an-even-month,D15,"NPD")
2 Replies
- naythorCopper ContributorThank you, Hans.