FORMULA
 

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.

Hi

=(Month(K4)<11)*10
will do

Arvi Laanemets


"JAUSTIN" wrote in message
...
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.

Hi
use
=IF(OR(MONTH(K4)={1,2,3,4,9,10,11,12}),10,0)?

--
Regards
Frank Kabel
Frankfurt, Germany

"JAUSTIN" schrieb im Newsbeitrag
...
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.

Hi Arvi
don't think this will work for th OP's specification :-)))

--
Regards
Frank Kabel
Frankfurt, Germany

"Arvi Laanemets" schrieb im Newsbeitrag
...
Hi

=(Month(K4)<11)*10
will do

Arvi Laanemets


"JAUSTIN" wrote in message
...
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.

Oops! I didn't read carefully enough. But then how about this?
=(OR(Month(K4)<5,MONTH(K4)8)*10


Arvi Laanemets


"Frank Kabel" wrote in message
...
Hi Arvi
don't think this will work for th OP's specification :-)))

--
Regards
Frank Kabel
Frankfurt, Germany

"Arvi Laanemets" schrieb im Newsbeitrag
...
Hi

=(Month(K4)<11)*10
will do

Arvi Laanemets


"JAUSTIN" wrote in message
...
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.