G
Guest
Why does this formula only work for the 1st # (1) of the array in EXCEL
=IF(MONTH(K4)={1,2,3,4,9,10,11,12},10,0)? If the month is January, the
formula returns a value of 10 which is correct; however if the month is any
other correct valued month (Feburary, March, April, etc), the formula returns
0 which is incorrect.
=IF(MONTH(K4)={1,2,3,4,9,10,11,12},10,0)? If the month is January, the
formula returns a value of 10 which is correct; however if the month is any
other correct valued month (Feburary, March, April, etc), the formula returns
0 which is incorrect.