Forum Discussion

naythor's avatar
naythor
Copper Contributor
May 01, 2021
Solved

Excel IF function

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,...
  • HansVogelaar's avatar
    May 01, 2021

    naythor 

    Use the following formula:

     

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

Resources