Thread: Formula
View Single Post
  #1   Report Post  
Deepwater
 
Posts: n/a
Default Formula

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.