May 01 2021 02:17 PM
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")
May 01 2021 02:25 PM
SolutionMay 01 2021 02:25 PM
Solution