|Syntax :||ABS( any_numeric_value)|
|Parameters :||any_numeric_value: Any positive or negative numbers|
|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."
|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
|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
|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.
|Evaluate the range B2 to B7 with value greater than 0 and range C2 to C7 with value of 0|