Formula

D

Deepwater

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 certain
months say Jan or March, it should take "24" in cell C4 other wise "0"

Thanks inadvance.
 
D

Dave O

The MONTH() function will returns an integer, 1 thru 12, representing
the month number of a date. In your example, the formula in C4 might
be
=IF(OR(MONTH(B4)=1,MONTH(B4)=3),24,0)

This formula checks the month number of the date in B4, and if it is
either January or March, returns the value 24.

Is this what you're looking for?
 
Top