formulas

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

need help pls - 18 Oct 2006 12:14 GMT

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

Reply to this Message

JLatham - 18 Oct 2006 13:08 GMT

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.

> hi people...doing a finance assignment using an excel model...just struggling
> abit with some of the formulas - any input is appreciated:
[quoted text clipped - 12 lines]
>
> thanks heaps

Reply to this Message

need help pls - 18 Oct 2006 14:08 GMT

I am getting a #NAME? error

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

> 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
[quoted text clipped - 21 lines]
> >
> > thanks heaps

Reply to this Message

Dave Peterson - 18 Oct 2006 14:28 GMT

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.

> I am getting a #NAME? error
>
[quoted text clipped - 25 lines]
> > >
> > > thanks heaps

Signature

Dave Peterson

Reply to this Message