Function name Type and description ABS function Math and trigonometry: Returns the absolute value of a number ACCRINT function Financial: Returns the accrued interest for a security that pays periodic interest ACCRINTM function Financial: Returns the accrued interest for a security that pays int...
Function name Type and description ABS function Math and trigonometry: Returns the absolute value of a number ACCRINT function Financial: Returns the accrued interest for a security that pays periodic interest ACCRINTM function Financial: Returns the accrued interest for a security that pays int...
If you are someone who doesn’t want to write formulas again and again, you can use the macro below to create custom function that can take month name (short and long) and then convert it into a number. Function MonthNameToNumber(monthName As String) As Integer ' This function converts ...
AMORDEGRC: 返回每个结算期间的折旧值,该函数主要为法国会计系统提供。 格式:=AMORDEGRC(原值,购入日期,结束日期,残值,期间,利率,基准选项) 原值:固定资产原值 购入日期:购入资产的日期。 结束日期:第一个期间结束时的日期。 残值:资产使用年限结束时的估计残值。 期间:进行折旧计算的期次,它必须与前者使用相同的单位。
function_num:1到11(本函数包含11个函数,你需要指定使用哪一个函数。) Range:需要进行计算的区域 ◇应用场景 同样是给星爷计算业绩,你对销售员进行了筛选。你会发现,如果使用SUM求的话,不受筛选结果影响,会对所有数据进行求和。而SUBTOTAL,他只对筛选数据...
=CHOOSE(MONTH(A1),"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec") When the month function returns a month number from the date, choose function will return the custom month name instead of that number. ...
5、EXCEL版本，公式易于理解，复制即用。下载地址 http://club.excelhome.net/thread-792587-1-1.html...
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any> 要使用的日计数基础的类型。 返回 Excel.FunctionResult<number> 注解 [ API 集:ExcelApi 1.2 ] acos(number) 返回数字的反正弦值,以弧度为单位,范围为 0 到 Pi。 反余弦值是余弦为数字的角度。 acos(numb...
Excel MONTH() function : This function is used to return the month of a date represented by a serial number. The month is given as an integer, ranging from 1 (January) to 12 (December).
Function calendar(grid)grid_date = grid year = Mid(grid_date, 1, 4)num1 = InStr(grid_date, "-")num2 = InStr(6, grid_date, "-")If (num2 - num1) = 3 Then month = Mid(grid_date, 6, 2)day = Mid(grid_date, 9, 2)Else month = Mid(grid_date, 6, 1)day =...