SOLVED

Excel IF function

%3CLINGO-SUB%20id%3D%22lingo-sub-2314284%22%20slang%3D%22en-US%22%3EExcel%20IF%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2314284%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I'm%20working%20on%20a%20budget%20spreadsheet.%20Cell%20B1%20is%20a%20date.%20I%20need%20to%20output%20what's%20in%20cell%20D15%20if%20the%20month%20in%20cell%20B1%20is%20an%20even%20month%20otherwise%20output%20NPD.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(B1(month)%3D%3CSTRONG%3E%3CU%3Ean-even-month%3C%2FU%3E%3C%2FSTRONG%3E%2CD15%2C%22NPD%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2314284%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2314330%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20IF%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2314330%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1042738%22%20target%3D%22_blank%22%3E%40naythor%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EUse%20the%20following%20formula%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIF(ISEVEN(MONTH(B1))%2CD15%2C%22NPD%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2314335%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20IF%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2314335%22%20slang%3D%22en-US%22%3EThank%20you%2C%20Hans.%3C%2FLINGO-BODY%3E
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.