I am looking for a formula, that assiagn certain values for certain months.

for example : i want to compare the date in Cell B4, if it falls in
following months it should asign following values each month
for Jan, March, June, Aug, Sep = 24 , July=72 and remaining months " 0 "

Thanks inadvance.

Deepwater,

Try:

=IF(OR(MONTH(B4)={1,3,6,8,9}),24,IF(MONTH(B4)=7,72 ,0))

HTH

Sandy
--
to e-mail direct replace @mailinator.com with @tiscali.co.uk


"Deepwater" wrote in message
...
I am looking for a formula, that assiagn certain values for certain
months.

for example : i want to compare the date in Cell B4, if it falls in
following months it should asign following values each month
for Jan, March, June, Aug, Sep = 24 , July=72 and remaining months " 0 "

Thanks inadvance.

One way:

=24*(SUMPRODUCT(--(MONTH($B$4)={1,3,6,8,9}))+3*(MONTH(B4)=7))

In article ,
Deepwater wrote:

I am looking for a formula, that assiagn certain values for certain months.

for example : i want to compare the date in Cell B4, if it falls in
following months it should asign following values each month
for Jan, March, June, Aug, Sep = 24 , July=72 and remaining months " 0 "

Thanks inadvance.

Thanks JE

I got it..

"JE McGimpsey" wrote:

One way:

=24*(SUMPRODUCT(--(MONTH($B$4)={1,3,6,8,9}))+3*(MONTH(B4)=7))

In article ,
Deepwater wrote:

I am looking for a formula, that assiagn certain values for certain months.

for example : i want to compare the date in Cell B4, if it falls in
following months it should asign following values each month
for Jan, March, June, Aug, Sep = 24 , July=72 and remaining months " 0 "

Thanks inadvance.

Thanks Sandy
I got it..
"Deepwater" wrote:

I am looking for a formula, that assiagn certain values for certain months.

for example : i want to compare the date in Cell B4, if it falls in
following months it should asign following values each month
for Jan, March, June, Aug, Sep = 24 , July=72 and remaining months " 0 "

Thanks inadvance.