SOLVED

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. 

 

=IF(B1(month)=an-even-month,D15,"NPD")

 

 

 

 

 

2 Replies
best response confirmed by naythor (New Contributor)
Solution

@naythor 

Use the following formula:

 

=IF(ISEVEN(MONTH(B1)),D15,"NPD")

Thank you, Hans.