Hello everyone.

I have in C2 a date that is pulled from another cell

C2 = March 1, 2005

I have a formula that needs to be modified to include either:

=IF(MONTH(C2)=3,"04101",IF(MONTH(C2)=4,"04102",IF( MONTH(C2)=5,"04100",0)))

I would type out all of the months but we are only allowed 7 nested funcitons.

What I need is:
if the month is either 1,4,7, 10 return 04101
if the month is either 2,5,8,11 return 04102
if the month is either 3,6,9,12 return 04100
otherwise leave blank.

How do I say this in the formula?

I tried using the commas to separate the different months but the message
came up I had an something wrong.

=IF(MONTH(C2)=1,4,7,10,"04101",IF(MONTH(C2)=2,5,8, 11,"04102",IF(MONTH(C2)=3,6,9,12,"04100",0)))

Thanks for your help.