Ima_learnin'
Active Member
- Joined
- Dec 14, 2002
- Messages
- 266
Hello All,
I have JAN,FEB,MAR…..NOV,DEC in range D7:D18…..I’m stumped…Along E7:E18…I need a formula that evaluates if the cell value is JAN, FEB or MAR return 1st Quarter, if the cell value is APR, MAY, or JUN return 2nd Quarter…so one and so forth until 4th quarter.
As always thanks!!
Ima Learnin’
I have JAN,FEB,MAR…..NOV,DEC in range D7:D18…..I’m stumped…Along E7:E18…I need a formula that evaluates if the cell value is JAN, FEB or MAR return 1st Quarter, if the cell value is APR, MAY, or JUN return 2nd Quarter…so one and so forth until 4th quarter.
As always thanks!!
Ima Learnin’