Modifying if statement in Excel
Posted on 2015-01-07
I have an if statement throughout a spreadsheet which only caculates the value if it is the month is less than the current month. It worked fine, until I tried to calculate December which is greater than January. I had not included year in the "if statement".
This is my statement,
=IF( MONTH(1&"-"&E$7) < MONTH(TODAY()),SUMIFS(MCLAIMS,MMONTH,MONTH(1&"-"&E$7),MEDIT,$C9),0)
Can someone tell me the best way to modify this statement so it will work all year, including December