excelqueen
New Member
- Joined
- May 2, 2002
- Messages
- 18
Hi There,
I want to know if there is a better alternative to the multiple IF construct? This is what i am trying to do - based on the value selected in a cell i want to autofill the other corresponding cells in the same row.
Example - if A1 (representing month) = October, November or December then B1 should be autofilled with a value "Q4 - Last quarter of the year"
Will appreciate help on this!
I want to know if there is a better alternative to the multiple IF construct? This is what i am trying to do - based on the value selected in a cell i want to autofill the other corresponding cells in the same row.
Example - if A1 (representing month) = October, November or December then B1 should be autofilled with a value "Q4 - Last quarter of the year"
Will appreciate help on this!