Excel IF function

New Contributor

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. 








2 Replies
best response confirmed by naythor (New Contributor)


Use the following formula:



Thank you, Hans.