## Excel Detail

 ABS Syntax : ABS( any_numeric_value) Parameters : any_numeric_value: Any positive or negative numbers Example: ACCRINT Syntax: ACCRINT( issue, first_interest, settlement, rate, [par], frequency, [basis], [calc_method] ) Parameters: Issue: The date the security is issued. first_interest: The date when the initial interest is paid. settlement: The settlement date of the security. rate: The annual interest rate or coupon when the security was issued. par: The par value of the security. frequency: The number of coupon payments per year: 1 = annual 2 = semi annual (default) 4 = quarterly basis (Optional): The type of day counting to use: 0 = US 30/360 (default) 1 = Actual/Actual 2 = Actual/360 3 = Actual/365 4 = European 30/360 calc_method (Optional): The start date for the accrued interest: True = start accruing interest from the issue date. False = start accruing interest from the last coupon payment date." Example: DATEDIF Syntax: DATEDIF(start_date,end_date,unit) Parameters: Start_date: Start dates (for example, "1/1/2017") End_date: Last date (for example, "4/10/2017") Unit can be entered as upper case or lowe case: "Y" = year "M" = month "D" = day "MD" = The number of days. Months are ignored. "YM" = The number of months. Years are ignored "YD" = he number of days. Years are ignored Example: COUNTIF Syntax: COUNTIF (range, criteria) Parameters: range - The range of cells to count. criteria - The criteria that controls which cells should be counted. Example: COUNTIF(A1:A11, 40) -> Count cells equal to 40 COUNTIF(A1:A11," > 40") -> Count cells greater than 40 COUNTIF(A1:A11, "Ben") -> Count cells contains the word "Ben" COUNTIF(A1:A11, "<" & B2) -> Count cells less than the value in B2 COUNTIF(C85,"*criteria") -> Count in cel C85 contain any words on the left and the word "criteria" COUNTIF(C85,"criter?a") -> Count in cel C85 contain "criter" and "a" with any letter in between COUNTIFS Syntax: COUNTIFS(range1, criteria1, range2, criteria2]…) Parameters: range1 - The range of cells to count in range1. criteria1 - The criteria that controls in range1 to be counted. range2 - The range of cells to count in range2. criteria2 - The criteria that controls in range2 to be counted. Example: COUNTIFS(B2:B7,">0", C2:C7,"=0") Evaluate the range B2 to B7 with value greater than 0 and range C2 to C7 with value of 0