formulas
 

hi people...doing a finance assignment using an excel model...just struggling
abit with some of the formulas - any input is appreciated:


=EOMONTH(DATE(YEAR(Model_Start_Date)+1*(MONTH(Mode l_Start_Date)MATCH(Per_1_End_Mth,LU_Mths,0)),MATC H(Per_1_End_Mth,LU_Mths,0),1),0)


=CHOOSE(DD_Model_Per_Type,
Yr_Name,
IF(MONTH(Per_1_End_Date)=DD_Fin_YE_Mth,Half_2,
Half_1),
IF(MONTH(Per_1_End_Date)=DD_Fin_YE_Mth,Qtr_4,
IF(ABS(MONTH(Per_1_End_Date)-DD_Fin_YE_Mth)=Mths_In_Half_Yr,Qtr_2,
IF(OR(MONTH(Per_1_End_Date)-DD_Fin_YE_Mth=-Mths_In_Qtr,MONTH(Per_1_End_Date)-DD_Fin_YE_Mth=3*Mths_In_Qtr),Qtr_3,
Qtr_1))),
"M"&MONTH(Per_1_End_Date)-DD_Fin_YE_Mth+(DD_Fin_YE_Mth=MONTH(Per_1_End_Date ))*Mths_In_Yr)

thanks heaps

formulas
 

We need a little help also, please explain what problem(s) you are having
with which formula. What, if any, relationship does either formula have to
do with the other (i.e., is the first formula given a name that is used in
the second one like maybe Per_1_End_Date ?).

What error are you getting? One thing that might help you to diagnose the
problem is to take each one of the Choose options and put them in individual
cells to see what each is calculating at any given time.

"need help pls" wrote:

hi people...doing a finance assignment using an excel model...just struggling
abit with some of the formulas - any input is appreciated:


=EOMONTH(DATE(YEAR(Model_Start_Date)+1*(MONTH(Mode l_Start_Date)MATCH(Per_1_End_Mth,LU_Mths,0)),MATC H(Per_1_End_Mth,LU_Mths,0),1),0)


=CHOOSE(DD_Model_Per_Type,
Yr_Name,
IF(MONTH(Per_1_End_Date)=DD_Fin_YE_Mth,Half_2,
Half_1),
IF(MONTH(Per_1_End_Date)=DD_Fin_YE_Mth,Qtr_4,
IF(ABS(MONTH(Per_1_End_Date)-DD_Fin_YE_Mth)=Mths_In_Half_Yr,Qtr_2,
IF(OR(MONTH(Per_1_End_Date)-DD_Fin_YE_Mth=-Mths_In_Qtr,MONTH(Per_1_End_Date)-DD_Fin_YE_Mth=3*Mths_In_Qtr),Qtr_3,
Qtr_1))),
"M"&MONTH(Per_1_End_Date)-DD_Fin_YE_Mth+(DD_Fin_YE_Mth=MONTH(Per_1_End_Date ))*Mths_In_Yr)

thanks heaps

formulas
 

I am getting a #NAME? error

it involves the dates on each of the sheets, but i can't quite work out how

"JLatham" wrote:

We need a little help also, please explain what problem(s) you are having
with which formula. What, if any, relationship does either formula have to
do with the other (i.e., is the first formula given a name that is used in
the second one like maybe Per_1_End_Date ?).

What error are you getting? One thing that might help you to diagnose the
problem is to take each one of the Choose options and put them in individual
cells to see what each is calculating at any given time.

"need help pls" wrote:

hi people...doing a finance assignment using an excel model...just struggling
abit with some of the formulas - any input is appreciated:


=EOMONTH(DATE(YEAR(Model_Start_Date)+1*(MONTH(Mode l_Start_Date)MATCH(Per_1_End_Mth,LU_Mths,0)),MATC H(Per_1_End_Mth,LU_Mths,0),1),0)


=CHOOSE(DD_Model_Per_Type,
Yr_Name,
IF(MONTH(Per_1_End_Date)=DD_Fin_YE_Mth,Half_2,
Half_1),
IF(MONTH(Per_1_End_Date)=DD_Fin_YE_Mth,Qtr_4,
IF(ABS(MONTH(Per_1_End_Date)-DD_Fin_YE_Mth)=Mths_In_Half_Yr,Qtr_2,
IF(OR(MONTH(Per_1_End_Date)-DD_Fin_YE_Mth=-Mths_In_Qtr,MONTH(Per_1_End_Date)-DD_Fin_YE_Mth=3*Mths_In_Qtr),Qtr_3,
Qtr_1))),
"M"&MONTH(Per_1_End_Date)-DD_Fin_YE_Mth+(DD_Fin_YE_Mth=MONTH(Per_1_End_Date ))*Mths_In_Yr)

thanks heaps

formulas
 

From excel's help for EOMonth:

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.

Click the How button inside that help for more info.

need help pls wrote:

I am getting a #NAME? error

it involves the dates on each of the sheets, but i can't quite work out how

"JLatham" wrote:

We need a little help also, please explain what problem(s) you are having
with which formula. What, if any, relationship does either formula have to
do with the other (i.e., is the first formula given a name that is used in
the second one like maybe Per_1_End_Date ?).

What error are you getting? One thing that might help you to diagnose the
problem is to take each one of the Choose options and put them in individual
cells to see what each is calculating at any given time.

"need help pls" wrote:

hi people...doing a finance assignment using an excel model...just struggling
abit with some of the formulas - any input is appreciated:


=EOMONTH(DATE(YEAR(Model_Start_Date)+1*(MONTH(Mode l_Start_Date)MATCH(Per_1_End_Mth,LU_Mths,0)),MATC H(Per_1_End_Mth,LU_Mths,0),1),0)


=CHOOSE(DD_Model_Per_Type,
Yr_Name,
IF(MONTH(Per_1_End_Date)=DD_Fin_YE_Mth,Half_2,
Half_1),
IF(MONTH(Per_1_End_Date)=DD_Fin_YE_Mth,Qtr_4,
IF(ABS(MONTH(Per_1_End_Date)-DD_Fin_YE_Mth)=Mths_In_Half_Yr,Qtr_2,
IF(OR(MONTH(Per_1_End_Date)-DD_Fin_YE_Mth=-Mths_In_Qtr,MONTH(Per_1_End_Date)-DD_Fin_YE_Mth=3*Mths_In_Qtr),Qtr_3,
Qtr_1))),
"M"&MONTH(Per_1_End_Date)-DD_Fin_YE_Mth+(DD_Fin_YE_Mth=MONTH(Per_1_End_Date ))*Mths_In_Yr)

thanks heaps



--

Dave Peterson