SOLVED

Excel IF function

Copper 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 (Copper Contributor)
Solution

@naythor 

Use the following formula:

 

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

Thank you, Hans.
1 best response

Accepted Solutions
best response confirmed by naythor (Copper Contributor)
Solution

@naythor 

Use the following formula:

 

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

View solution in original post