Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change column letters to correct ones in many formulas automatically? | Links and Linking in Excel | |||
how can i get formulas in excel to copy and paste? | Excel Worksheet Functions | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |