alternative for nested IF function?

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!
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
You can do this with a lookup table. On an empty area of your worksheet or on another sheet, create a column of the twelve months. In the next column to the right type in the descriptions you want, e.g. Q1 - First quarter of the year, Q2 - Second quarter of the year etc. Thus:
January Q1 - First quarter of the year
FebruaryQ1 - First quarter of the year
March Q1 - First quarter of the year
April Q2 - Second quarter of the year
May Q2 - Second quarter of the year
June Q2 - Second quarter of the year
July Q3 - Third quarter of the year
August Q3 - Third quarter of the year
SeptemberQ3 - Third quarter of the year
October Q4 - Last quarter of the year
NovemberQ4 - Last quarter of the year
DecemberQ4 - Last quarter of the year

Select the range containing all the 24 cells. Name it CalendarRange.
In B1 type =VLOOKUP(A1,CalendarRange,2,0). Autofill this down if you want to repeat the lookup on other rows. If you change the month in A1, B1 will change automatically.

This Message was edited by: inarbeth on 2002-05-05 01:34 ]</font>
This message was edited by inarbeth on 2002-05-05 01:37
 
Upvote 0
On 2002-05-05 01:36, Schrödinger’s cat wrote:
Or in B1 put =IF(OR(A1="October",A1="November",A1="December"),"Q4 - Last quarter of year","")

a slight timesaver :

=IF(OR(A1={"October","November","December"}),"Q4 - Last quarter of year","")
 
Upvote 0

Forum statistics

Threads
1,213,543
Messages
6,114,245
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top