DEAR FOURM FRIENDS,
I HAVE CELL,A1=25 AND B1=7500 AND C1=MONTH.I WANT TO CALCULATE AS;IF MONTH IS =28 THEN:B1/28*A1 AND IF MONTHIS=30 THEN:B1/30*A1 AND IF MONTH IS =31 THEN:B1/31*A1 TELL ME WHAT IS FARMULA FOR THIS CALCULATION.calculation will be do automatically when the month change.
