formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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(Model_Start_Date)>MATCH(Per_1_End_Mth,LU_Mths,0)),MATCH(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
 
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.
 
I am getting a #NAME? error

it involves the dates on each of the sheets, but i can't quite work out how
 
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.
 
Back
Top