Excel VBAリファレンス(WorksheetFunctionオブジェクト編)
WorksheetFunctionオブジェクトは、Visual BasicからExcelのワークシート関数を呼び出す際のコンテナとして使用され、全てのワークシート関数に対応するメソッドが提供されています。
⇒Excel VBAの主なオブジェクトについては、Excel VBAリファレンス(Excel VBAのオブジェクト構造編)を参照して下さい。
■WorksheetFunctionオブジェクトの詳細
WorksheetFunctionオブジェクトで提供されているメソッドとプロパティは下表の通りです。
WorksheetFunctionオブジェクトのメソッド
AccrIntメソッド | |||||||||||
説明 | 定期的に利息が支払われる証券の未収利息額を返す | ||||||||||
定義 | Function AccrInt(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, [Arg7 As Variant]) As Double | ||||||||||
AccrIntMメソッド | |||||||||||
説明 | 満期日に利息が支払われる証券の未収利息額を返す | ||||||||||
定義 | Function AccrIntM(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, [Arg5 As Variant]) As Double | ||||||||||
Acosメソッド | |||||||||||
説明 | 数値の逆余弦を返す | ||||||||||
定義 | Function Acos(Arg1 As Double) As Double | ||||||||||
Acoshメソッド | |||||||||||
説明 | 数値の逆双曲線余弦を返す | ||||||||||
定義 | Function Acosh(Arg1 As Double) As Double | ||||||||||
Acotメソッド | |||||||||||
説明 | 数値の逆余接を返す | ||||||||||
定義 | Function Acot(Arg1 As Double) As Double | ||||||||||
Acothメソッド | |||||||||||
説明 | 数値の逆双曲線余接を返す | ||||||||||
定義 | Function Acoth(Arg1 As Double) As Double | ||||||||||
Aggregateメソッド | |||||||||||
説明 | リストまたはデータベースの総計を返す | ||||||||||
定義 | Function Aggregate(Arg1 As Double, Arg2 As Double, Arg3 As Range, [Arg4 As Variant], [Arg5 As Variant], [Arg6 As Variant], [Arg7 As Variant], [Arg8 As Variant], [Arg9 As Variant], [Arg10 As Variant], [Arg11 As Variant], [Arg12 As Variant], [Arg13 As Variant], [Arg14 As Variant], [Arg15 As Variant], [Arg16 As Variant], [Arg17 As Variant], [Arg18 As Variant], [Arg19 As Variant], [Arg20 As Variant], [Arg21 As Variant], [Arg22 As Variant], [Arg23 As Variant], [Arg24 As Variant], [Arg25 As Variant], [Arg26 As Variant], [Arg27 As Variant], [Arg28 As Variant], [Arg29 As Variant], [Arg30 As Variant]) As Double | ||||||||||
AmorDegrcメソッド | |||||||||||
説明 | 減価償却係数を使用して各会計期における減価償却費を返す | ||||||||||
定義 | Function AmorDegrc(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, [Arg7 As Variant]) As Double | ||||||||||
AmorLincメソッド | |||||||||||
説明 | 各会計期における減価償却費を返す | ||||||||||
定義 | Function AmorLinc(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, [Arg7 As Variant]) As Double | ||||||||||
Andメソッド | |||||||||||
説明 | 複数条件の論理積を返す | ||||||||||
定義 | Function And(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, Arg7 As Variant, Arg8 As Variant, Arg9 As Variant, Arg10 As Variant, Arg11 As Variant, Arg12 As Variant, Arg13 As Variant, Arg14 As Variant, Arg15 As Variant, Arg16 As Variant, Arg17 As Variant, Arg18 As Variant, Arg19 As Variant, Arg20 As Variant, Arg21 As Variant, Arg22 As Variant, Arg23 As Variant, Arg24 As Variant, Arg25 As Variant, Arg26 As Variant, Arg27 As Variant, Arg28 As Variant, Arg29 As Variant, Arg30 As Variant) As Boolean | ||||||||||
Arabicメソッド | |||||||||||
説明 | ローマ数字をアラビア数字に変換する | ||||||||||
定義 | Function Arabic(Arg1 As String) As Double | ||||||||||
Ascメソッド | |||||||||||
説明 | 全角(2バイト)の英数カナ文字を半角(1バイト)の文字に変換する | ||||||||||
定義 | Function Asc(Arg1 As String) As String | ||||||||||
Asinメソッド | |||||||||||
説明 | 数値の逆正弦を返す | ||||||||||
定義 | Function Asin(Arg1 As Double) As Double | ||||||||||
Asinhメソッド | |||||||||||
説明 | 数値の逆双曲線正弦を返す | ||||||||||
定義 | Function Asinh(Arg1 As Double) As Double | ||||||||||
Atan2メソッド | |||||||||||
説明 | 指定したx-y座標の逆正接を返す | ||||||||||
定義 | Function Atan2(Arg1 As Double, Arg2 As Double) As Double | ||||||||||
Atanhメソッド | |||||||||||
説明 | 数値の逆双曲線正接を返す | ||||||||||
定義 | Function Atanh(Arg1 As Double) As Double | ||||||||||
AveDevメソッド | |||||||||||
説明 | 指定したデータの平均値に対するそれぞれのデータの絶対偏差の平均を返す | ||||||||||
定義 | Function AveDev(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, Arg7 As Variant, Arg8 As Variant, Arg9 As Variant, Arg10 As Variant, Arg11 As Variant, Arg12 As Variant, Arg13 As Variant, Arg14 As Variant, Arg15 As Variant, Arg16 As Variant, Arg17 As Variant, Arg18 As Variant, Arg19 As Variant, Arg20 As Variant, Arg21 As Variant, Arg22 As Variant, Arg23 As Variant, Arg24 As Variant, Arg25 As Variant, Arg26 As Variant, Arg27 As Variant, Arg28 As Variant, Arg29 As Variant, Arg30 As Variant) As Double | ||||||||||
Averageメソッド | |||||||||||
説明 | 指定したデータの平均値(算術平均)を返す | ||||||||||
定義 | Function Average(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, Arg7 As Variant, Arg8 As Variant, Arg9 As Variant, Arg10 As Variant, Arg11 As Variant, Arg12 As Variant, Arg13 As Variant, Arg14 As Variant, Arg15 As Variant, Arg16 As Variant, Arg17 As Variant, Arg18 As Variant, Arg19 As Variant, Arg20 As Variant, Arg21 As Variant, Arg22 As Variant, Arg23 As Variant, Arg24 As Variant, Arg25 As Variant, Arg26 As Variant, Arg27 As Variant, Arg28 As Variant, Arg29 As Variant, Arg30 As Variant) As Double | ||||||||||
AverageIfメソッド | |||||||||||
説明 | 範囲内の検索条件に一致する全てのセルの平均値(算術平均)を返す | ||||||||||
定義 | Function AverageIf(Arg1 As Range, Arg2 As Variant, [Arg3 As Variant]) As Double | ||||||||||
AverageIfsメソッド | |||||||||||
説明 | 複数の検索条件に一致する全てのセルの平均値(算術平均)を返す | ||||||||||
定義 | Function AverageIfs(Arg1 As Range, Arg2 As Range, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, Arg7 As Variant, Arg8 As Variant, Arg9 As Variant, Arg10 As Variant, Arg11 As Variant, Arg12 As Variant, Arg13 As Variant, Arg14 As Variant, Arg15 As Variant, Arg16 As Variant, Arg17 As Variant, Arg18 As Variant, Arg19 As Variant, Arg20 As Variant, Arg21 As Variant, Arg22 As Variant, Arg23 As Variant, Arg24 As Variant, Arg25 As Variant, Arg26 As Variant, Arg27 As Variant, Arg28 As Variant, Arg29 As Variant) As Double | ||||||||||
BahtTextメソッド | |||||||||||
説明 | バーツ(ß)通貨書式を使用して数値を文字列に変換する | ||||||||||
定義 | Function BahtText(Arg1 As Double) As String | ||||||||||
Baseメソッド | |||||||||||
説明 | 数値を指定した基数(底)のテキスト表現に変換する | ||||||||||
定義 | Function Base(Arg1 As Double, Arg2 As Double, [Arg3 As Variant]) As String | ||||||||||
BesselIメソッド | |||||||||||
説明 | 修正ベッセル関数In(x)を返す | ||||||||||
定義 | Function BesselI(Arg1 As Variant, Arg2 As Variant) As Double | ||||||||||
BesselJメソッド | |||||||||||
説明 | ベッセル関数Jn(x)を返す | ||||||||||
定義 | Function BesselJ(Arg1 As Variant, Arg2 As Variant) As Double | ||||||||||
BesselKメソッド | |||||||||||
説明 | 修正ベッセル関数Kn(x)を返す | ||||||||||
定義 | Function BesselK(Arg1 As Variant, Arg2 As Variant) As Double | ||||||||||
BesselYメソッド | |||||||||||
説明 | ベッセル関数Yn(x)を返す | ||||||||||
定義 | Function BesselY(Arg1 As Variant, Arg2 As Variant) As Double | ||||||||||
Beta_Distメソッド | |||||||||||
説明 | β分布の累積分布関数または確率密度関数の値を返す | ||||||||||
定義 | Function Beta_Dist(Arg1 As Double, Arg2 As Double, Arg3 As Double, [Arg4 As Boolean], [Arg5 As Variant], [Arg6 As Variant]) As Double | ||||||||||
Beta_Invメソッド | |||||||||||
説明 | 指定したβ分布の累積分布関数の逆関数値を返す | ||||||||||
定義 | Function Beta_Inv(Arg1 As Double, Arg2 As Double, Arg3 As Double, [Arg4 As Variant], [Arg5 As Variant]) As Double | ||||||||||
BetaDistメソッド | |||||||||||
説明 | β分布の累積分布関数の値を返す | ||||||||||
定義 | Function BetaDist(Arg1 As Double, Arg2 As Double, Arg3 As Double, [Arg4 As Variant], [Arg5 As Variant]) As Double | ||||||||||
BetaInvメソッド | |||||||||||
説明 | 指定したβ分布の累積分布関数の逆関数値を返す | ||||||||||
定義 | Function BetaInv(Arg1 As Double, Arg2 As Double, Arg3 As Double, [Arg4 As Variant], [Arg5 As Variant]) As Double | ||||||||||
Bin2Decメソッド | |||||||||||
説明 | 2進数を10進数に変換する | ||||||||||
定義 | Function Bin2Dec(Arg1 As Variant) As String | ||||||||||
Bin2Hexメソッド | |||||||||||
説明 | 2進数を16進数に変換する | ||||||||||
定義 | Function Bin2Hex(Arg1 As Variant, [Arg2 As Variant]) As String | ||||||||||
Bin2Octメソッド | |||||||||||
説明 | 2進数を8進数に変換する | ||||||||||
定義 | Function Bin2Oct(Arg1 As Variant, [Arg2 As Variant]) As String | ||||||||||
Binom_Distメソッド | |||||||||||
説明 | 二項分布の累積分布関数または確率密度関数の値を返す | ||||||||||
定義 | Function Binom_Dist(Arg1 As Double, Arg2 As Double, Arg3 As Double, Arg4 As Boolean) As Double | ||||||||||
Binom_Dist_Rangeメソッド | |||||||||||
説明 | 二項分布を使用した試行結果の確率を返す | ||||||||||
定義 | Function Binom_Dist_Range(Arg1 As Double, Arg2 As Double, Arg3 As Double, [Arg4 As Variant]) As Double | ||||||||||
Binom_Invメソッド | |||||||||||
説明 | 累積二項分布の値が基準値以下になるような最小の値を返す | ||||||||||
定義 | Function Binom_Inv(Arg1 As Double, Arg2 As Double, Arg3 As Double) As Double | ||||||||||
BinomDistメソッド | |||||||||||
説明 | 二項分布の累積分布関数または確率密度関数の値を返す | ||||||||||
定義 | Function BinomDist(Arg1 As Double, Arg2 As Double, Arg3 As Double, Arg4 As Boolean) As Double | ||||||||||
Bitandメソッド | |||||||||||
説明 | 2つの数値のビット演算’AND’を返す | ||||||||||
定義 | Function Bitand(Arg1 As Double, Arg2 As Double) As Double | ||||||||||
Bitlshiftメソッド | |||||||||||
説明 | 指定したビットの数だけ左にシフトした数値を返す | ||||||||||
定義 | Function Bitlshift(Arg1 As Double, Arg2 As Double) As Double | ||||||||||
Bitorメソッド | |||||||||||
説明 | 2つの数値のビット演算’OR’を返す | ||||||||||
定義 | Function Bitor(Arg1 As Double, Arg2 As Double) As Double | ||||||||||
Bitrshiftメソッド | |||||||||||
説明 | 指定したビットの数だけ右にシフトした数値を返す | ||||||||||
定義 | Function Bitrshift(Arg1 As Double, Arg2 As Double) As Double | ||||||||||
Bitxorメソッド | |||||||||||
説明 | 2つの数値のビット演算’XOR’を返す | ||||||||||
定義 | Function Bitxor(Arg1 As Double, Arg2 As Double) As Double | ||||||||||
Ceilingメソッド | |||||||||||
説明 | 指定した基準値の倍数のうち、最も近い値に数値を切り上げる | ||||||||||
定義 | Function Ceiling(Arg1 As Double, Arg2 As Double) As Double | ||||||||||
Ceiling_Mathメソッド | |||||||||||
説明 | 数値を最も近い整数または基準値に最も近い倍数に切り上げる | ||||||||||
定義 | Function Ceiling_Math(Arg1 As Double, [Arg2 As Variant], [Arg3 As Variant]) As Double | ||||||||||
Ceiling_Preciseメソッド | |||||||||||
説明 | 指定した基準値の倍数のうち、最も近い値に数値を丸める | ||||||||||
定義 | Function Ceiling_Precise(Arg1 As Double, [Arg2 As Variant]) As Double | ||||||||||
ChiDistメソッド | |||||||||||
説明 | カイ2乗分布の片側確率の値を返す | ||||||||||
定義 | Function ChiDist(Arg1 As Double, Arg2 As Double) As Double | ||||||||||
ChiInvメソッド | |||||||||||
説明 | カイ2乗分布の片側確率の逆関数値を返す | ||||||||||
定義 | Function ChiInv(Arg1 As Double, Arg2 As Double) As Double | ||||||||||
ChiSq_Distメソッド | |||||||||||
説明 | カイ2乗分布の確率密度関数の値を返す | ||||||||||
定義 | Function ChiSq_Dist(Arg1 As Double, Arg2 As Double, [Arg3 As Boolean]) As Double | ||||||||||
ChiSq_Dist_RTメソッド | |||||||||||
説明 | カイ2乗分布の右側確率の値を返す | ||||||||||
定義 | Function ChiSq_Dist_RT(Arg1 As Double, Arg2 As Double) As Double | ||||||||||
ChiSq_Invメソッド | |||||||||||
説明 | カイ2乗分布の左側確率の逆関数値を返す | ||||||||||
定義 | Function ChiSq_Inv(Arg1 As Double, Arg2 As Double) As Double | ||||||||||
ChiSq_Inv_RTメソッド | |||||||||||
説明 | カイ2乗分布の右側確率の逆関数値を返す | ||||||||||
定義 | Function ChiSq_Inv_RT(Arg1 As Double, Arg2 As Double) As Double | ||||||||||
ChiSq_Testメソッド | |||||||||||
説明 | カイ2乗(χ2)検定の結果を返す | ||||||||||
定義 | Function ChiSq_Test(Arg1 As Variant, Arg2 As Variant) As Double | ||||||||||
ChiTestメソッド | |||||||||||
説明 | カイ2乗(χ2)検定の結果を返す | ||||||||||
定義 | Function ChiTest(Arg1 As Variant, Arg2 As Variant) As Double | ||||||||||
Chooseメソッド | |||||||||||
説明 | 値のリストから値を選択する | ||||||||||
定義 | Function Choose(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, Arg7 As Variant, Arg8 As Variant, Arg9 As Variant, Arg10 As Variant, Arg11 As Variant, Arg12 As Variant, Arg13 As Variant, Arg14 As Variant, Arg15 As Variant, Arg16 As Variant, Arg17 As Variant, Arg18 As Variant, Arg19 As Variant, Arg20 As Variant, Arg21 As Variant, Arg22 As Variant, Arg23 As Variant, Arg24 As Variant, Arg25 As Variant, Arg26 As Variant, Arg27 As Variant, Arg28 As Variant, Arg29 As Variant, Arg30 As Variant) As Variant | ||||||||||
Cleanメソッド | |||||||||||
説明 | 印刷できない文字を文字列から削除する | ||||||||||
定義 | Function Clean(Arg1 As String) As String | ||||||||||
Combinメソッド | |||||||||||
説明 | 指定した個数を選択する時の組合せの数を返す | ||||||||||
定義 | Function Combin(Arg1 As Double, Arg2 As Double) As Double | ||||||||||
Combinaメソッド | |||||||||||
説明 | 指定した個数を選択する時の組合せ(反復あり)の数を返す | ||||||||||
定義 | Function Combina(Arg1 As Double, Arg2 As Double) As Double | ||||||||||
Complexメソッド | |||||||||||
説明 | 実数係数と虚数係数を複素数に変換する | ||||||||||
定義 | Function Complex(Arg1 As Variant, Arg2 As Variant, [Arg3 As Variant]) As String | ||||||||||
Confidenceメソッド | |||||||||||
説明 | 母集団の平均に対する信頼区間を返す | ||||||||||
定義 | Function Confidence(Arg1 As Double, Arg2 As Double, Arg3 As Double) As Double | ||||||||||
Confidence_Normメソッド | |||||||||||
説明 | 母集団の平均に対する信頼区間を返す | ||||||||||
定義 | Function Confidence_Norm(Arg1 As Double, Arg2 As Double, Arg3 As Double) As Double | ||||||||||
Confidence_Tメソッド | |||||||||||
説明 | スチューデントのt分布を使用して母集団の平均に対する信頼区間を返す | ||||||||||
定義 | Function Confidence_T(Arg1 As Double, Arg2 As Double, Arg3 As Double) As Double | ||||||||||
Convertメソッド | |||||||||||
説明 | 数値の単位を変換する | ||||||||||
定義 | Function Convert(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant) As Double | ||||||||||
Correlメソッド | |||||||||||
説明 | 指定した2つの配列データの相関係数を返す | ||||||||||
定義 | Function Correl(Arg1 As Variant, Arg2 As Variant) As Double | ||||||||||
Coshメソッド | |||||||||||
説明 | 数値の双曲線余弦を返す | ||||||||||
定義 | Function Cosh(Arg1 As Double) As Double | ||||||||||
Cotメソッド | |||||||||||
説明 | 数値の余接を返す | ||||||||||
定義 | Function Cot(Arg1 As Double) As Double | ||||||||||
Cothメソッド | |||||||||||
説明 | 数値の双曲線余接を返す | ||||||||||
定義 | Function Coth(Arg1 As Double) As Double | ||||||||||
Countメソッド | |||||||||||
説明 | 指定したデータに含まれる数値の個数を返す | ||||||||||
定義 | Function Count(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, Arg7 As Variant, Arg8 As Variant, Arg9 As Variant, Arg10 As Variant, Arg11 As Variant, Arg12 As Variant, Arg13 As Variant, Arg14 As Variant, Arg15 As Variant, Arg16 As Variant, Arg17 As Variant, Arg18 As Variant, Arg19 As Variant, Arg20 As Variant, Arg21 As Variant, Arg22 As Variant, Arg23 As Variant, Arg24 As Variant, Arg25 As Variant, Arg26 As Variant, Arg27 As Variant, Arg28 As Variant, Arg29 As Variant, Arg30 As Variant) As Double | ||||||||||
CountAメソッド | |||||||||||
説明 | 指定したデータに含まれる数値の個数を返す | ||||||||||
定義 | Function CountA(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, Arg7 As Variant, Arg8 As Variant, Arg9 As Variant, Arg10 As Variant, Arg11 As Variant, Arg12 As Variant, Arg13 As Variant, Arg14 As Variant, Arg15 As Variant, Arg16 As Variant, Arg17 As Variant, Arg18 As Variant, Arg19 As Variant, Arg20 As Variant, Arg21 As Variant, Arg22 As Variant, Arg23 As Variant, Arg24 As Variant, Arg25 As Variant, Arg26 As Variant, Arg27 As Variant, Arg28 As Variant, Arg29 As Variant, Arg30 As Variant) As Double | ||||||||||
CountBlankメソッド | |||||||||||
説明 | 指定した範囲に含まれる空白セルの個数を返す | ||||||||||
定義 | Function CountBlank(Arg1 As Range) As Double | ||||||||||
CountIfメソッド | |||||||||||
説明 | 指定した範囲に含まれるセルのうち、検索条件に一致するセルの個数を返す | ||||||||||
定義 | Function CountIf(Arg1 As Range, Arg2 As Variant) As Double | ||||||||||
CountIfsメソッド | |||||||||||
説明 | 指定した範囲に含まれるセルのうち、複数の検索条件に一致するセルの個数を返す | ||||||||||
定義 | Function CountIfs(Arg1 As Range, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, Arg7 As Variant, Arg8 As Variant, Arg9 As Variant, Arg10 As Variant, Arg11 As Variant, Arg12 As Variant, Arg13 As Variant, Arg14 As Variant, Arg15 As Variant, Arg16 As Variant, Arg17 As Variant, Arg18 As Variant, Arg19 As Variant, Arg20 As Variant, Arg21 As Variant, Arg22 As Variant, Arg23 As Variant, Arg24 As Variant, Arg25 As Variant, Arg26 As Variant, Arg27 As Variant, Arg28 As Variant, Arg29 As Variant, Arg30 As Variant) As Double | ||||||||||
CoupDayBsメソッド | |||||||||||
説明 | 利払期間の第1日目から受渡日までの日数を返す | ||||||||||
定義 | Function CoupDayBs(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, [Arg4 As Variant]) As Double | ||||||||||
CoupDaysメソッド | |||||||||||
説明 | 受渡日を含む利払期間内の日数を返す | ||||||||||
定義 | Function CoupDays(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, [Arg4 As Variant]) As Double | ||||||||||
CoupDaysNcメソッド | |||||||||||
説明 | 受渡日から次の利払日までの日数を返す | ||||||||||
定義 | Function CoupDaysNc(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, [Arg4 As Variant]) As Double | ||||||||||
CoupNcdメソッド | |||||||||||
説明 | 受渡日後の次の利払日を返す | ||||||||||
定義 | Function CoupNcd(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, [Arg4 As Variant]) As Double | ||||||||||
CoupNumメソッド | |||||||||||
説明 | 受渡日と満期日の間の利払回数を返す | ||||||||||
定義 | Function CoupNum(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, [Arg4 As Variant]) As Double | ||||||||||
CoupPcdメソッド | |||||||||||
説明 | 受渡日の直前の利払日を返す | ||||||||||
定義 | Function CoupPcd(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, [Arg4 As Variant]) As Double | ||||||||||
Covarメソッド | |||||||||||
説明 | 共分散を返す | ||||||||||
定義 | Function Covar(Arg1 As Variant, Arg2 As Variant) As Double | ||||||||||
Covariance_Pメソッド | |||||||||||
説明 | 母集団の共分散を返す | ||||||||||
定義 | Function Covariance_P(Arg1 As Variant, Arg2 As Variant) As Double | ||||||||||
Covariance_Sメソッド | |||||||||||
説明 | 標本の共分散を返す | ||||||||||
定義 | Function Covariance_S(Arg1 As Variant, Arg2 As Variant) As Double | ||||||||||
CritBinomメソッド | |||||||||||
説明 | 累積二項分布の値が基準値以下になるような最小の値を返す | ||||||||||
定義 | Function CritBinom(Arg1 As Double, Arg2 As Double, Arg3 As Double) As Double | ||||||||||
Cscメソッド | |||||||||||
説明 | 数値の余割を返す | ||||||||||
定義 | Function Csc(Arg1 As Double) As Double | ||||||||||
Cschメソッド | |||||||||||
説明 | 数値の双曲線余割を返す | ||||||||||
定義 | Function Csch(Arg1 As Double) As Double | ||||||||||
CumIPmtメソッド | |||||||||||
説明 | 指定した期間に支払われる利息の累計を返す | ||||||||||
定義 | Function CumIPmt(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant) As Double | ||||||||||
CumPrincメソッド | |||||||||||
説明 | 指定した期間に支払われる元金の累計を返す | ||||||||||
定義 | Function CumPrinc(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant) As Double | ||||||||||
DAverageメソッド | |||||||||||
説明 | 選択したデータベースレコードの平均値を返す | ||||||||||
定義 | Function DAverage(Arg1 As Range, Arg2 As Variant, Arg3 As Variant) As Double | ||||||||||
Daysメソッド | |||||||||||
説明 | 2つの日付間の日数を返します | ||||||||||
定義 | Function Days(Arg1 As Variant, Arg2 As Variant) As Double | ||||||||||
Days360メソッド | |||||||||||
説明 | 1年を360日として、2つの日付間の日数を返す | ||||||||||
定義 | Function Days360(Arg1 As Variant, Arg2 As Variant, [Arg3 As Variant]) As Double | ||||||||||
Dbメソッド | |||||||||||
説明 | 定率法を利用して、特定の期における資産の減価償却費を返す | ||||||||||
定義 | Function Db(Arg1 As Double, Arg2 As Double, Arg3 As Double, Arg4 As Double, [Arg5 As Variant]) As Double | ||||||||||
Dbcsメソッド | |||||||||||
説明 | 文字列内の半角(1バイト)の英数カナ文字を全角(2バイト)の文字に変換する | ||||||||||
定義 | Function Dbcs(Arg1 As String) As String | ||||||||||
DCountメソッド | |||||||||||
説明 | データベース内にある数値を含むセルの個数を返す | ||||||||||
定義 | Function DCount(Arg1 As Range, Arg2 As Variant, Arg3 As Variant) As Double | ||||||||||
DCountAメソッド | |||||||||||
説明 | データベース内にある空白でないセルの個数を返す | ||||||||||
定義 | Function DCountA(Arg1 As Range, Arg2 As Variant, Arg3 As Variant) As Double | ||||||||||
Ddbメソッド | |||||||||||
説明 | 倍額定率法または指定した他の方法を使用して、特定の期における資産の減価償却費を返す | ||||||||||
定義 | Function Ddb(Arg1 As Double, Arg2 As Double, Arg3 As Double, Arg4 As Double, [Arg5 As Variant]) As Double | ||||||||||
Dec2Binメソッド | |||||||||||
説明 | 10進数を2進数に変換する | ||||||||||
定義 | Function Dec2Bin(Arg1 As Variant, [Arg2 As Variant]) As String | ||||||||||
Dec2Hexメソッド | |||||||||||
説明 | 10進数を16進数に変換する | ||||||||||
定義 | Function Dec2Hex(Arg1 As Variant, [Arg2 As Variant]) As String | ||||||||||
Dec2Octメソッド | |||||||||||
説明 | 10進数を8進数に変換する | ||||||||||
定義 | Function Dec2Oct(Arg1 As Variant, [Arg2 As Variant]) As String | ||||||||||
Decimalメソッド | |||||||||||
説明 | 指定した底の数値のテキスト表現を10進数に変換する | ||||||||||
定義 | Function Decimal(Arg1 As String, Arg2 As Double) As Double | ||||||||||
Degreesメソッド | |||||||||||
説明 | ラジアンを度に変換する | ||||||||||
定義 | Function Degrees(Arg1 As Double) As Double | ||||||||||
Deltaメソッド | |||||||||||
説明 | 2つの値が等しいかどうかを調べる | ||||||||||
定義 | Function Delta(Arg1 As Variant, [Arg2 As Variant]) As Double | ||||||||||
DevSqメソッド | |||||||||||
説明 | 標本の偏差の平方和を返す | ||||||||||
定義 | Function DevSq(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, Arg7 As Variant, Arg8 As Variant, Arg9 As Variant, Arg10 As Variant, Arg11 As Variant, Arg12 As Variant, Arg13 As Variant, Arg14 As Variant, Arg15 As Variant, Arg16 As Variant, Arg17 As Variant, Arg18 As Variant, Arg19 As Variant, Arg20 As Variant, Arg21 As Variant, Arg22 As Variant, Arg23 As Variant, Arg24 As Variant, Arg25 As Variant, Arg26 As Variant, Arg27 As Variant, Arg28 As Variant, Arg29 As Variant, Arg30 As Variant) As Double | ||||||||||
DGetメソッド | |||||||||||
説明 | 指定した条件に一致する1つのレコードをデータベースから抽出する | ||||||||||
定義 | Function DGet(Arg1 As Range, Arg2 As Variant, Arg3 As Variant) As Variant | ||||||||||
Discメソッド | |||||||||||
説明 | 証券に対する割引率を返す | ||||||||||
定義 | Function Disc(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, [Arg5 As Variant]) As Double | ||||||||||
DMaxメソッド | |||||||||||
説明 | 選択したデータベースレコードの最大値を返す | ||||||||||
定義 | Function DMax(Arg1 As Range, Arg2 As Variant, Arg3 As Variant) As Double | ||||||||||
DMinメソッド | |||||||||||
説明 | 選択したデータベースレコードの最小値を返す | ||||||||||
定義 | Function DMin(Arg1 As Range, Arg2 As Variant, Arg3 As Variant) As Double | ||||||||||
Dollarメソッド | |||||||||||
説明 | ドル($)通貨書式を使用して数値を文字列に変換する | ||||||||||
定義 | Function Dollar(Arg1 As Double, [Arg2 As Variant]) As String | ||||||||||
DollarDeメソッド | |||||||||||
説明 | 分数で表されたドル単位の価格を小数表示のドル価格に変換する | ||||||||||
定義 | Function DollarDe(Arg1 As Variant, Arg2 As Variant) As Double | ||||||||||
DollarFrメソッド | |||||||||||
説明 | 小数で表されたドル単位の価格を分数表示のドル価格に変換する | ||||||||||
定義 | Function DollarFr(Arg1 As Variant, Arg2 As Variant) As Double | ||||||||||
DProductメソッド | |||||||||||
説明 | データベース内の条件に一致するレコードの特定のフィールド値を乗算する | ||||||||||
定義 | Function DProduct(Arg1 As Range, Arg2 As Variant, Arg3 As Variant) As Double | ||||||||||
DStDevメソッド | |||||||||||
説明 | 選択したデータベースレコードを標本とみなして推定した母集団の標準偏差を返す | ||||||||||
定義 | Function DStDev(Arg1 As Range, Arg2 As Variant, Arg3 As Variant) As Double | ||||||||||
DStDevPメソッド | |||||||||||
説明 | 選択したデータベースレコードを母集団全体とみなして算出した標準偏差を返す | ||||||||||
定義 | Function DStDevP(Arg1 As Range, Arg2 As Variant, Arg3 As Variant) As Double | ||||||||||
DSumメソッド | |||||||||||
説明 | データベース内の条件に一致するレコードのフィールド列にある数値を合計する | ||||||||||
定義 | Function DSum(Arg1 As Range, Arg2 As Variant, Arg3 As Variant) As Double | ||||||||||
Durationメソッド | |||||||||||
説明 | 定期的に利子が支払われる証券の年間のマコーレーデュレーションを返す | ||||||||||
定義 | Function Duration(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, [Arg6 As Variant]) As Double | ||||||||||
DVarメソッド | |||||||||||
説明 | 選択したデータベースレコードを標本とみなして推定した母集団の分散を返す | ||||||||||
定義 | Function DVar(Arg1 As Range, Arg2 As Variant, Arg3 As Variant) As Double | ||||||||||
DVarPメソッド | |||||||||||
説明 | 選択したデータベースレコードを母集団全体とみなして算出した分散を返す | ||||||||||
定義 | Function DVarP(Arg1 As Range, Arg2 As Variant, Arg3 As Variant) As Double | ||||||||||
EDateメソッド | |||||||||||
説明 | 開始日から起算して指定した月数だけ前または後の日付に対応するシリアル値を返す | ||||||||||
定義 | Function EDate(Arg1 As Variant, Arg2 As Variant) As Double | ||||||||||
Effectメソッド | |||||||||||
説明 | 実効年利率を返す | ||||||||||
定義 | Function Effect(Arg1 As Variant, Arg2 As Variant) As Double | ||||||||||
EncodeURLメソッド | |||||||||||
説明 | URL形式でエンコードされた文字列を返す | ||||||||||
定義 | Function EncodeURL(Arg1 As String) As Variant | ||||||||||
EoMonthメソッド | |||||||||||
説明 | 指定した月数だけ前または後の月の最終日に対応するシリアル値を返す | ||||||||||
定義 | Function EoMonth(Arg1 As Variant, Arg2 As Variant) As Double | ||||||||||
Erfメソッド | |||||||||||
説明 | 下限~上限の範囲で誤差関数の積分値を返す | ||||||||||
定義 | Function Erf(Arg1 As Variant, [Arg2 As Variant]) As Double | ||||||||||
Erf_Preciseメソッド | |||||||||||
説明 | 0~指定した値の範囲で誤差関数の積分値を返す | ||||||||||
定義 | Function Erf_Precise(Arg1 As Variant) As Double | ||||||||||
ErfCメソッド | |||||||||||
説明 | 指定した値~無限大の範囲で相補誤差関数の積分値を返す | ||||||||||
定義 | Function ErfC(Arg1 As Variant, [Arg2 As Variant]) As Double | ||||||||||
ErfC_Preciseメソッド | |||||||||||
説明 | 指定した値~無限大の範囲で相補誤差関数の積分値を返す | ||||||||||
定義 | Function ErfC_Precise(Arg1 As Variant) As Double | ||||||||||
Evenメソッド | |||||||||||
説明 | 指定した数値を最も近い偶数に切り上げた値を返す | ||||||||||
定義 | Function Even(Arg1 As Double) As Double | ||||||||||
Expon_Distメソッド | |||||||||||
説明 | 指数分布の累積分布関数または確率密度関数の値を返す | ||||||||||
定義 | Function Expon_Dist(Arg1 As Double, Arg2 As Double, Arg3 As Boolean) As Double | ||||||||||
ExponDistメソッド | |||||||||||
説明 | 指数分布の累積分布関数または確率密度関数の値を返す | ||||||||||
定義 | Function ExponDist(Arg1 As Double, Arg2 As Double, Arg3 As Boolean) As Double | ||||||||||
F_Distメソッド | |||||||||||
説明 | F分布の累積分布関数または確率密度関数の値を返す | ||||||||||
定義 | Function F_Dist(Arg1 As Double, Arg2 As Double, Arg3 As Double, [Arg4 As Boolean]) As Double | ||||||||||
F_Dist_RTメソッド | |||||||||||
説明 | F分布の右側確率密度関数の値を返す | ||||||||||
定義 | Function F_Dist_RT(Arg1 As Double, Arg2 As Double, Arg3 As Double) As Double | ||||||||||
F_Invメソッド | |||||||||||
説明 | F分布の確率密度関数の逆関数の値を返す(指定した確率と自由度からF値を求める際に使用) | ||||||||||
定義 | Function F_Inv(Arg1 As Double, Arg2 As Double, Arg3 As Double) As Double | ||||||||||
F_Inv_RTメソッド | |||||||||||
説明 | F分布の右側確率密度関数の逆関数の値を返す(指定した確率と自由度からF値を求める際に使用) | ||||||||||
定義 | Function F_Inv_RT(Arg1 As Double, Arg2 As Double, Arg3 As Double) As Double | ||||||||||
F_Testメソッド | |||||||||||
説明 | F検定の結果を返す | ||||||||||
定義 | Function F_Test(Arg1 As Variant, Arg2 As Variant) As Double | ||||||||||
Factメソッド | |||||||||||
説明 | 数値の階乗を返す | ||||||||||
定義 | Function Fact(Arg1 As Double) As Double | ||||||||||
FactDoubleメソッド | |||||||||||
説明 | 数値の二重階乗を返す | ||||||||||
定義 | Function FactDouble(Arg1 As Variant) As Double | ||||||||||
FDistメソッド | |||||||||||
説明 | F分布の確率密度関数の値を返す | ||||||||||
定義 | Function FDist(Arg1 As Double, Arg2 As Double, Arg3 As Double) As Double | ||||||||||
FilterXMLメソッド | |||||||||||
説明 | 指定したXPathに基いてXMLコンテンツの特定のデータを返す | ||||||||||
定義 | Function FilterXML(Arg1 As String, Arg2 As String) As Variant | ||||||||||
Findメソッド | |||||||||||
説明 | 指定したテキスト値を他のテキスト値の中で検索する(1バイト文字セットで使用) | ||||||||||
定義 | Function Find(Arg1 As String, Arg2 As String, [Arg3 As Variant]) As Double | ||||||||||
FindBメソッド | |||||||||||
説明 | 指定したテキスト値を他のテキスト値の中で検索する(2バイト文字セットで使用) | ||||||||||
定義 | Function FindB(Arg1 As String, Arg2 As String, [Arg3 As Variant]) As Double | ||||||||||
FInvメソッド | |||||||||||
説明 | F分布の確率密度関数の逆関数の値を返す(指定した確率と自由度からF値を求める際に使用) | ||||||||||
定義 | Function FInv(Arg1 As Double, Arg2 As Double, Arg3 As Double) As Double | ||||||||||
Fisherメソッド | |||||||||||
説明 | フィッシャー変換の値を返す | ||||||||||
定義 | Function Fisher(Arg1 As Double) As Double | ||||||||||
FisherInvメソッド | |||||||||||
説明 | フィッシャー変換の逆関数値を返す | ||||||||||
定義 | Function FisherInv(Arg1 As Double) As Double | ||||||||||
Fixedメソッド | |||||||||||
説明 | 数値を四捨五入し、一定の桁数で書式設定した文字列に変換する | ||||||||||
定義 | Function Fixed(Arg1 As Double, [Arg2 As Variant], [Arg3 As Variant]) As String | ||||||||||
Floorメソッド | |||||||||||
説明 | 数値を指定した桁数で切り捨てる | ||||||||||
定義 | Function Floor(Arg1 As Double, Arg2 As Double) As Double | ||||||||||
Floor_Mathメソッド | |||||||||||
説明 | 数値を最も近い整数または基準値に最も近い倍数に切り下げる | ||||||||||
定義 | Function Floor_Math(Arg1 As Double, [Arg2 As Variant], [Arg3 As Variant]) As Double | ||||||||||
Floor_Preciseメソッド | |||||||||||
説明 | 指定した基準値の倍数のうち、最も近い値に数値を丸める | ||||||||||
定義 | Function Floor_Precise(Arg1 As Double, [Arg2 As Variant]) As Double | ||||||||||
Forecastメソッド | |||||||||||
説明 | 回帰直線を使用して将来を予測する | ||||||||||
定義 | Function Forecast(Arg1 As Double, Arg2 As Variant, Arg3 As Variant) As Double | ||||||||||
Forecast_ETSメソッド | |||||||||||
説明 | 指数平滑法を使用して将来を予測する | ||||||||||
定義 | Function Forecast_ETS(Arg1 As Double, Arg2 As Variant, Arg3 As Variant, [Arg4 As Variant], [Arg5 As Variant], [Arg6 As Variant]) As Double | ||||||||||
Forecast_ETS_ConfIntメソッド | |||||||||||
説明 | 指数平滑法を使用して、指定した日付の予測値に対する信頼区間を返す | ||||||||||
定義 | Function Forecast_ETS_ConfInt(Arg1 As Double, Arg2 As Variant, Arg3 As Variant, [Arg4 As Variant], [Arg5 As Variant], [Arg6 As Variant], [Arg7 As Variant]) As Double | ||||||||||
Forecast_ETS_Seasonalityメソッド | |||||||||||
説明 | 指数平滑法を使用して、指定した時系列の繰り返しパターンの長さを返す | ||||||||||
定義 | Function Forecast_ETS_Seasonality(Arg1 As Double, Arg2 As Variant, [Arg3 As Variant], [Arg4 As Variant]) As Double | ||||||||||
Forecast_ETS_STATメソッド | |||||||||||
説明 | 指数平滑法を使用して、時系列予測の結果の統計値を返す | ||||||||||
定義 | Function Forecast_ETS_STAT(Arg1 As Double, Arg2 As Variant, Arg3 As Variant, [Arg4 As Variant], [Arg5 As Variant], [Arg6 As Variant]) As Double | ||||||||||
Forecast_Linearメソッド | |||||||||||
説明 | 回帰直線を使用して将来を予測する | ||||||||||
定義 | Function Forecast_Linear(Arg1 As Double, Arg2 As Variant, Arg3 As Variant) As Double | ||||||||||
Frequencyメソッド | |||||||||||
説明 | 頻度分布を計算し、垂直配列として返す | ||||||||||
定義 | Function Frequency(Arg1 As Variant, Arg2 As Variant) As Variant | ||||||||||
FTestメソッド | |||||||||||
説明 | F検定の結果を返す | ||||||||||
定義 | Function FTest(Arg1 As Variant, Arg2 As Variant) As Double | ||||||||||
Fvメソッド | |||||||||||
説明 | 定額の支払いを定期的に行い、利率が一定であると仮定して、投資の将来価値を返す | ||||||||||
定義 | Function Fv(Arg1 As Double, Arg2 As Double, Arg3 As Double, [Arg4 As Variant], [Arg5 As Variant]) As Double | ||||||||||
FVScheduleメソッド | |||||||||||
説明 | 一連の金利を複利計算することにより、初期投資した元金の将来価値を返す | ||||||||||
定義 | Function FVSchedule(Arg1 As Variant, Arg2 As Variant) As Double | ||||||||||
Gammaメソッド | |||||||||||
説明 | ガンマ関数の値を返す | ||||||||||
定義 | Function Gamma(Arg1 As Double) As Double | ||||||||||
Gamma_Distメソッド | |||||||||||
説明 | ガンマ分布の累積分布関数または確率密度関数の値を返す | ||||||||||
定義 | Function Gamma_Dist(Arg1 As Double, Arg2 As Double, Arg3 As Double, Arg4 As Boolean) As Double | ||||||||||
Gamma_Invメソッド | |||||||||||
説明 | ガンマ分布の累積分布関数の逆関数値を返す | ||||||||||
定義 | Function Gamma_Inv(Arg1 As Double, Arg2 As Double, Arg3 As Double) As Double | ||||||||||
GammaDistメソッド | |||||||||||
説明 | ガンマ分布の累積分布関数または確率密度関数の値を返す | ||||||||||
定義 | Function GammaDist(Arg1 As Double, Arg2 As Double, Arg3 As Double, Arg4 As Boolean) As Double | ||||||||||
GammaInvメソッド | |||||||||||
説明 | ガンマ分布の累積分布関数の逆関数値を返す | ||||||||||
定義 | Function GammaInv(Arg1 As Double, Arg2 As Double, Arg3 As Double) As Double | ||||||||||
GammaLnメソッド | |||||||||||
説明 | ガンマ関数Γ(x)の値の自然対数を返す | ||||||||||
定義 | Function GammaLn(Arg1 As Double) As Double | ||||||||||
GammaLn_Preciseメソッド | |||||||||||
説明 | ガンマ関数Γ(x)の値の自然対数を返す | ||||||||||
定義 | Function GammaLn_Precise(Arg1 As Double) As Double | ||||||||||
Gaussメソッド | |||||||||||
説明 | 標準正規分布の累積分布関数より0.5小さい値を返す | ||||||||||
定義 | Function Gauss(Arg1 As Double) As Double | ||||||||||
Gcdメソッド | |||||||||||
説明 | 指定した整数の最大公約数を返す | ||||||||||
定義 | Function Gcd(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, Arg7 As Variant, Arg8 As Variant, Arg9 As Variant, Arg10 As Variant, Arg11 As Variant, Arg12 As Variant, Arg13 As Variant, Arg14 As Variant, Arg15 As Variant, Arg16 As Variant, Arg17 As Variant, Arg18 As Variant, Arg19 As Variant, Arg20 As Variant, Arg21 As Variant, Arg22 As Variant, Arg23 As Variant, Arg24 As Variant, Arg25 As Variant, Arg26 As Variant, Arg27 As Variant, Arg28 As Variant, Arg29 As Variant, Arg30 As Variant) As Double | ||||||||||
GeoMeanメソッド | |||||||||||
説明 | 指定したデータの相乗平均を返す | ||||||||||
定義 | Function GeoMean(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, Arg7 As Variant, Arg8 As Variant, Arg9 As Variant, Arg10 As Variant, Arg11 As Variant, Arg12 As Variant, Arg13 As Variant, Arg14 As Variant, Arg15 As Variant, Arg16 As Variant, Arg17 As Variant, Arg18 As Variant, Arg19 As Variant, Arg20 As Variant, Arg21 As Variant, Arg22 As Variant, Arg23 As Variant, Arg24 As Variant, Arg25 As Variant, Arg26 As Variant, Arg27 As Variant, Arg28 As Variant, Arg29 As Variant, Arg30 As Variant) As Double | ||||||||||
GeStepメソッド | |||||||||||
説明 | 数値が閾値以上であるかどうかを調べる | ||||||||||
定義 | Function GeStep(Arg1 As Variant, [Arg2 As Variant]) As Double | ||||||||||
Growthメソッド | |||||||||||
説明 | 指数曲線から予測される値を返す | ||||||||||
定義 | Function Growth(Arg1 As Variant, [Arg2 As Variant], [Arg3 As Variant], [Arg4 As Variant]) As Variant | ||||||||||
HarMeanメソッド | |||||||||||
説明 | 指定したデータの調和平均を返す | ||||||||||
定義 | Function HarMean(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, Arg7 As Variant, Arg8 As Variant, Arg9 As Variant, Arg10 As Variant, Arg11 As Variant, Arg12 As Variant, Arg13 As Variant, Arg14 As Variant, Arg15 As Variant, Arg16 As Variant, Arg17 As Variant, Arg18 As Variant, Arg19 As Variant, Arg20 As Variant, Arg21 As Variant, Arg22 As Variant, Arg23 As Variant, Arg24 As Variant, Arg25 As Variant, Arg26 As Variant, Arg27 As Variant, Arg28 As Variant, Arg29 As Variant, Arg30 As Variant) As Double | ||||||||||
Hex2Binメソッド | |||||||||||
説明 | 16進数を2進数に変換する | ||||||||||
定義 | Function Hex2Bin(Arg1 As Variant, [Arg2 As Variant]) As String | ||||||||||
Hex2Decメソッド | |||||||||||
説明 | 16進数を10進数に変換する | ||||||||||
定義 | Function Hex2Dec(Arg1 As Variant) As String | ||||||||||
Hex2Octメソッド | |||||||||||
説明 | 16進数を8進数に変換する | ||||||||||
定義 | Function Hex2Oct(Arg1 As Variant, [Arg2 As Variant]) As String | ||||||||||
HLookupメソッド | |||||||||||
説明 | 配列の上端行で特定の値を検索し、対応するセルの値を返す | ||||||||||
定義 | Function HLookup(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, [Arg4 As Variant]) As Variant | ||||||||||
HypGeom_Distメソッド | |||||||||||
説明 | 超幾何分布の累積分布関数または確率質量関数の値を返す | ||||||||||
定義 | Function HypGeom_Dist(Arg1 As Double, Arg2 As Double, Arg3 As Double, Arg4 As Double, [Arg5 As Boolean]) As Double | ||||||||||
HypGeomDistメソッド | |||||||||||
説明 | 超幾何分布の値を返す | ||||||||||
定義 | Function HypGeomDist(Arg1 As Double, Arg2 As Double, Arg3 As Double, Arg4 As Double) As Double | ||||||||||
IfErrorメソッド | |||||||||||
説明 | 数式の結果がエラーの場合は指定した値を返し、それ以外の場合は数式の結果を返す | ||||||||||
定義 | Function IfError(Arg1 As Variant, Arg2 As Variant) As Variant | ||||||||||
IfNaメソッド | |||||||||||
説明 | 値がない場合は指定した値を返し、それ以外の場合は数式の結果を返す | ||||||||||
定義 | Function IfNa(Arg1 As Variant, Arg2 As Variant) As Variant | ||||||||||
ImAbsメソッド | |||||||||||
説明 | 指定した複素数の絶対値を返す | ||||||||||
定義 | Function ImAbs(Arg1 As Variant) As String | ||||||||||
Imaginaryメソッド | |||||||||||
説明 | 指定した複素数の虚数係数を返す | ||||||||||
定義 | Function Imaginary(Arg1 As Variant) As Double | ||||||||||
ImArgumentメソッド | |||||||||||
説明 | 偏角シータをラジアンで返す | ||||||||||
定義 | Function ImArgument(Arg1 As Variant) As String | ||||||||||
ImConjugateメソッド | |||||||||||
説明 | 複素数の複素共役を返す | ||||||||||
定義 | Function ImConjugate(Arg1 As Variant) As String | ||||||||||
ImCosメソッド | |||||||||||
説明 | 複素数の余弦を返す | ||||||||||
定義 | Function ImCos(Arg1 As Variant) As String | ||||||||||
ImCoshメソッド | |||||||||||
説明 | 複素数の双曲線余弦を返す | ||||||||||
定義 | Function ImCosh(Arg1 As Variant) As String | ||||||||||
ImCotメソッド | |||||||||||
説明 | 複素数の余接を返す | ||||||||||
定義 | Function ImCot(Arg1 As Variant) As String | ||||||||||
ImCscメソッド | |||||||||||
説明 | 複素数の余割を返す | ||||||||||
定義 | Function ImCsc(Arg1 As Variant) As String | ||||||||||
ImCschメソッド | |||||||||||
説明 | 複素数の双曲線余割を返す | ||||||||||
定義 | Function ImCsch(Arg1 As Variant) As String | ||||||||||
ImDivメソッド | |||||||||||
説明 | 2つの複素数の商を返す | ||||||||||
定義 | Function ImDiv(Arg1 As Variant, Arg2 As Variant) As String | ||||||||||
ImExpメソッド | |||||||||||
説明 | 複素数のべき乗を返す | ||||||||||
定義 | Function ImExp(Arg1 As Variant) As String | ||||||||||
ImLnメソッド | |||||||||||
説明 | 複素数の自然対数を返す | ||||||||||
定義 | Function ImLn(Arg1 As Variant) As String | ||||||||||
ImLog10メソッド | |||||||||||
説明 | 複素数の10を底とする対数(常用対数)を返す | ||||||||||
定義 | Function ImLog10(Arg1 As Variant) As String | ||||||||||
ImLog2メソッド | |||||||||||
説明 | 複素数の2を底とする対数を返す | ||||||||||
定義 | Function ImLog2(Arg1 As Variant) As String | ||||||||||
ImPowerメソッド | |||||||||||
説明 | 複素数の整数乗を返す | ||||||||||
定義 | Function ImPower(Arg1 As Variant, Arg2 As Variant) As String | ||||||||||
ImProductメソッド | |||||||||||
説明 | 複素数の積を返す | ||||||||||
定義 | Function ImProduct(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, Arg7 As Variant, Arg8 As Variant, Arg9 As Variant, Arg10 As Variant, Arg11 As Variant, Arg12 As Variant, Arg13 As Variant, Arg14 As Variant, Arg15 As Variant, Arg16 As Variant, Arg17 As Variant, Arg18 As Variant, Arg19 As Variant, Arg20 As Variant, Arg21 As Variant, Arg22 As Variant, Arg23 As Variant, Arg24 As Variant, Arg25 As Variant, Arg26 As Variant, Arg27 As Variant, Arg28 As Variant, Arg29 As Variant, Arg30 As Variant) As String | ||||||||||
ImRealメソッド | |||||||||||
説明 | 複素数の実数係数を返す | ||||||||||
定義 | Function ImReal(Arg1 As Variant) As Double | ||||||||||
ImSecメソッド | |||||||||||
説明 | 複素数の正割を返す | ||||||||||
定義 | Function ImSec(Arg1 As Variant) As String | ||||||||||
ImSechメソッド | |||||||||||
説明 | 複素数の双曲線正割を返す | ||||||||||
定義 | Function ImSech(Arg1 As Variant) As String | ||||||||||
ImSinメソッド | |||||||||||
説明 | 複素数の正弦を返す | ||||||||||
定義 | Function ImSin(Arg1 As Variant) As String | ||||||||||
ImSinhメソッド | |||||||||||
説明 | 複素数の双曲線正弦を返す | ||||||||||
定義 | Function ImSinh(Arg1 As Variant) As String | ||||||||||
ImSqrtメソッド | |||||||||||
説明 | 複素数の平方根を返す | ||||||||||
定義 | Function ImSqrt(Arg1 As Variant) As String | ||||||||||
ImSubメソッド | |||||||||||
説明 | 2つの複素数の差を返す | ||||||||||
定義 | Function ImSub(Arg1 As Variant, Arg2 As Variant) As String | ||||||||||
ImSumメソッド | |||||||||||
説明 | 複素数の和を返す | ||||||||||
定義 | Function ImSum(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, Arg7 As Variant, Arg8 As Variant, Arg9 As Variant, Arg10 As Variant, Arg11 As Variant, Arg12 As Variant, Arg13 As Variant, Arg14 As Variant, Arg15 As Variant, Arg16 As Variant, Arg17 As Variant, Arg18 As Variant, Arg19 As Variant, Arg20 As Variant, Arg21 As Variant, Arg22 As Variant, Arg23 As Variant, Arg24 As Variant, Arg25 As Variant, Arg26 As Variant, Arg27 As Variant, Arg28 As Variant, Arg29 As Variant, Arg30 As Variant) As String | ||||||||||
ImTanメソッド | |||||||||||
説明 | 複素数の正接を返す | ||||||||||
定義 | Function ImTan(Arg1 As Variant) As String | ||||||||||
Indexメソッド | |||||||||||
説明 | セル参照または配列から指定した位置の値を返す | ||||||||||
定義 | Function Index(Arg1 As Variant, Arg2 As Double, [Arg3 As Variant], [Arg4 As Variant]) As Variant | ||||||||||
Interceptメソッド | |||||||||||
説明 | 線形回帰直線の切片を返す | ||||||||||
定義 | Function Intercept(Arg1 As Variant, Arg2 As Variant) As Double | ||||||||||
IntRateメソッド | |||||||||||
説明 | 全額投資された証券の利率を返す | ||||||||||
定義 | Function IntRate(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, [Arg5 As Variant]) As Double | ||||||||||
Ipmtメソッド | |||||||||||
説明 | 定額の支払いを定期的に行い、利率が一定であると仮定して、指定した期に支払われる金利を返す | ||||||||||
定義 | Function Ipmt(Arg1 As Double, Arg2 As Double, Arg3 As Double, Arg4 As Double, [Arg5 As Variant], [Arg6 As Variant]) As Double | ||||||||||
Irrメソッド | |||||||||||
説明 | 一連の定期的なキャッシュフローに対する内部利益率を返す | ||||||||||
定義 | Function Irr(Arg1 As Variant, [Arg2 As Variant]) As Double | ||||||||||
IsErrメソッド | |||||||||||
説明 | 指定した値が#N/A以外のエラーかどうか判定する | ||||||||||
定義 | Function IsErr(Arg1 As Variant) As Boolean | ||||||||||
IsErrorメソッド | |||||||||||
説明 | 指定した値がエラーかどうか判定する | ||||||||||
定義 | Function IsError(Arg1 As Variant) As Boolean | ||||||||||
IsEvenメソッド | |||||||||||
説明 | 指定した値が偶数かどうか判定する | ||||||||||
定義 | Function IsEven(Arg1 As Variant) As Boolean | ||||||||||
IsFormulaメソッド | |||||||||||
説明 | 指定した値が数式を含むかどうか判定する | ||||||||||
定義 | Function IsFormula(Arg1 As Range) As Boolean | ||||||||||
IsLogicalメソッド | |||||||||||
説明 | 指定した値が論理値かどうか判定する | ||||||||||
定義 | Function IsLogical(Arg1 As Variant) As Boolean | ||||||||||
IsNAメソッド | |||||||||||
説明 | 指定した値がエラー値’#N/A’かどうか判定する | ||||||||||
定義 | Function IsNA(Arg1 As Variant) As Boolean | ||||||||||
IsNonTextメソッド | |||||||||||
説明 | 指定した値が文字列以外かどうか判定する | ||||||||||
定義 | Function IsNonText(Arg1 As Variant) As Boolean | ||||||||||
IsNumberメソッド | |||||||||||
説明 | 指定した値が数値かどうか判定する | ||||||||||
定義 | Function IsNumber(Arg1 As Variant) As Boolean | ||||||||||
ISO_Ceilingメソッド | |||||||||||
説明 | 指定した基準値の倍数のうち、最も近い整数値に切り上げた値を返す | ||||||||||
定義 | Function ISO_Ceiling(Arg1 As Double, [Arg2 As Variant]) As Double | ||||||||||
IsOddメソッド | |||||||||||
説明 | 指定した値が奇数かどうか判定する | ||||||||||
定義 | Function IsOdd(Arg1 As Variant) As Boolean | ||||||||||
IsoWeekNumメソッド | |||||||||||
説明 | 指定した日付の年のISO週番号を返す | ||||||||||
定義 | Function IsoWeekNum(Arg1 As Double, [Arg2 As Variant]) As Double | ||||||||||
Ispmtメソッド | |||||||||||
説明 | 指定した期に支払われる金利を返す | ||||||||||
定義 | Function Ispmt(Arg1 As Double, Arg2 As Double, Arg3 As Double, Arg4 As Double) As Double | ||||||||||
IsTextメソッド | |||||||||||
説明 | 指定した値がテキストかどうか判定する | ||||||||||
定義 | Function IsText(Arg1 As Variant) As Boolean | ||||||||||
Kurtメソッド | |||||||||||
説明 | データセットの尖度を返す | ||||||||||
定義 | Function Kurt(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, Arg7 As Variant, Arg8 As Variant, Arg9 As Variant, Arg10 As Variant, Arg11 As Variant, Arg12 As Variant, Arg13 As Variant, Arg14 As Variant, Arg15 As Variant, Arg16 As Variant, Arg17 As Variant, Arg18 As Variant, Arg19 As Variant, Arg20 As Variant, Arg21 As Variant, Arg22 As Variant, Arg23 As Variant, Arg24 As Variant, Arg25 As Variant, Arg26 As Variant, Arg27 As Variant, Arg28 As Variant, Arg29 As Variant, Arg30 As Variant) As Double | ||||||||||
Largeメソッド | |||||||||||
説明 | 1つのデータセットの中で’順位’番目に大きなデータを返す | ||||||||||
定義 | Function Large(Arg1 As Variant, Arg2 As Double) As Double | ||||||||||
Lcmメソッド | |||||||||||
説明 | 指定した整数の最小公倍数を返す | ||||||||||
定義 | Function Lcm(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, Arg7 As Variant, Arg8 As Variant, Arg9 As Variant, Arg10 As Variant, Arg11 As Variant, Arg12 As Variant, Arg13 As Variant, Arg14 As Variant, Arg15 As Variant, Arg16 As Variant, Arg17 As Variant, Arg18 As Variant, Arg19 As Variant, Arg20 As Variant, Arg21 As Variant, Arg22 As Variant, Arg23 As Variant, Arg24 As Variant, Arg25 As Variant, Arg26 As Variant, Arg27 As Variant, Arg28 As Variant, Arg29 As Variant, Arg30 As Variant) As Double | ||||||||||
LinEstメソッド | |||||||||||
説明 | 線形トレンドのパラメータを返す | ||||||||||
定義 | Function LinEst(Arg1 As Variant, [Arg2 As Variant], [Arg3 As Variant], [Arg4 As Variant]) As Variant | ||||||||||
Lnメソッド | |||||||||||
説明 | 数値の自然対数を返す | ||||||||||
定義 | Function Ln(Arg1 As Double) As Double | ||||||||||
Logメソッド | |||||||||||
説明 | 指定した数を底とする数値の対数を返す | ||||||||||
定義 | Function Log(Arg1 As Double, [Arg2 As Variant]) As Double | ||||||||||
Log10メソッド | |||||||||||
説明 | 10を底とする数値の対数(常用対数)を返す | ||||||||||
定義 | Function Log10(Arg1 As Double) As Double | ||||||||||
LogEstメソッド | |||||||||||
説明 | 回帰指数曲線の係数の値を返す | ||||||||||
定義 | Function LogEst(Arg1 As Variant, [Arg2 As Variant], [Arg3 As Variant], [Arg4 As Variant]) As Variant | ||||||||||
LogInvメソッド | |||||||||||
説明 | 対数正規型の累積分布関数の逆関数値を返す | ||||||||||
定義 | Function LogInv(Arg1 As Double, Arg2 As Double, Arg3 As Double) As Double | ||||||||||
LogNorm_Distメソッド | |||||||||||
説明 | 対数の累積分布関数または確率密度関数の値を返す | ||||||||||
定義 | Function LogNorm_Dist(Arg1 As Double, Arg2 As Double, Arg3 As Double, [Arg4 As Boolean]) As Double | ||||||||||
LogNorm_Invメソッド | |||||||||||
説明 | 対数正規型の累積分布関数の逆関数値を返す | ||||||||||
定義 | Function LogNorm_Inv(Arg1 As Double, Arg2 As Double, Arg3 As Double) As Double | ||||||||||
LogNormDistメソッド | |||||||||||
説明 | 対数正規累積分布関数の値を返す | ||||||||||
定義 | Function LogNormDist(Arg1 As Double, Arg2 As Double, Arg3 As Double) As Double | ||||||||||
Lookupメソッド | |||||||||||
説明 | ベクトルまたは配列を検索して、対応する値を返す | ||||||||||
定義 | Function Lookup(Arg1 As Variant, Arg2 As Variant, [Arg3 As Variant]) As Variant | ||||||||||
Matchメソッド | |||||||||||
説明 | 指定した順序で指定した値と一致する配列内の項目の相対的な位置を返す | ||||||||||
定義 | Function Match(Arg1 As Variant, Arg2 As Variant, [Arg3 As Variant]) As Double | ||||||||||
Maxメソッド | |||||||||||
説明 | 指定したデータの最大値を返す | ||||||||||
定義 | Function Max(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, Arg7 As Variant, Arg8 As Variant, Arg9 As Variant, Arg10 As Variant, Arg11 As Variant, Arg12 As Variant, Arg13 As Variant, Arg14 As Variant, Arg15 As Variant, Arg16 As Variant, Arg17 As Variant, Arg18 As Variant, Arg19 As Variant, Arg20 As Variant, Arg21 As Variant, Arg22 As Variant, Arg23 As Variant, Arg24 As Variant, Arg25 As Variant, Arg26 As Variant, Arg27 As Variant, Arg28 As Variant, Arg29 As Variant, Arg30 As Variant) As Double | ||||||||||
MDetermメソッド | |||||||||||
説明 | 配列の行列式を返す | ||||||||||
定義 | Function MDeterm(Arg1 As Variant) As Double | ||||||||||
MDurationメソッド | |||||||||||
説明 | 額面価格を$100と仮定して、証券に対する修正済マコーレーデュレーションを返す | ||||||||||
定義 | Function MDuration(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, [Arg6 As Variant]) As Double | ||||||||||
Medianメソッド | |||||||||||
説明 | 指定したデータの中央値を返す | ||||||||||
定義 | Function Median(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, Arg7 As Variant, Arg8 As Variant, Arg9 As Variant, Arg10 As Variant, Arg11 As Variant, Arg12 As Variant, Arg13 As Variant, Arg14 As Variant, Arg15 As Variant, Arg16 As Variant, Arg17 As Variant, Arg18 As Variant, Arg19 As Variant, Arg20 As Variant, Arg21 As Variant, Arg22 As Variant, Arg23 As Variant, Arg24 As Variant, Arg25 As Variant, Arg26 As Variant, Arg27 As Variant, Arg28 As Variant, Arg29 As Variant, Arg30 As Variant) As Double | ||||||||||
Minメソッド | |||||||||||
説明 | 指定したデータの最小値を返す | ||||||||||
定義 | Function Min(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, Arg7 As Variant, Arg8 As Variant, Arg9 As Variant, Arg10 As Variant, Arg11 As Variant, Arg12 As Variant, Arg13 As Variant, Arg14 As Variant, Arg15 As Variant, Arg16 As Variant, Arg17 As Variant, Arg18 As Variant, Arg19 As Variant, Arg20 As Variant, Arg21 As Variant, Arg22 As Variant, Arg23 As Variant, Arg24 As Variant, Arg25 As Variant, Arg26 As Variant, Arg27 As Variant, Arg28 As Variant, Arg29 As Variant, Arg30 As Variant) As Double | ||||||||||
MInverseメソッド | |||||||||||
説明 | 行列の逆行列を返す | ||||||||||
定義 | Function MInverse(Arg1 As Variant) As Variant | ||||||||||
MIrrメソッド | |||||||||||
説明 | 一連の定期的なキャッシュフローに基いて修正内部利益率を返す | ||||||||||
定義 | Function MIrr(Arg1 As Variant, Arg2 As Double, Arg3 As Double) As Double | ||||||||||
MMultメソッド | |||||||||||
説明 | 2つの配列の行列積を返す | ||||||||||
定義 | Function MMult(Arg1 As Variant, Arg2 As Variant) As Variant | ||||||||||
Modeメソッド | |||||||||||
説明 | 指定したデータの最頻値を返す | ||||||||||
定義 | Function Mode(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, Arg7 As Variant, Arg8 As Variant, Arg9 As Variant, Arg10 As Variant, Arg11 As Variant, Arg12 As Variant, Arg13 As Variant, Arg14 As Variant, Arg15 As Variant, Arg16 As Variant, Arg17 As Variant, Arg18 As Variant, Arg19 As Variant, Arg20 As Variant, Arg21 As Variant, Arg22 As Variant, Arg23 As Variant, Arg24 As Variant, Arg25 As Variant, Arg26 As Variant, Arg27 As Variant, Arg28 As Variant, Arg29 As Variant, Arg30 As Variant) As Double | ||||||||||
Mode_Multメソッド | |||||||||||
説明 | 指定したデータの最頻値を垂直配列で返す | ||||||||||
定義 | Function Mode_Mult(Arg1 As Variant, [Arg2 As Variant], [Arg3 As Variant], [Arg4 As Variant], [Arg5 As Variant], [Arg6 As Variant], [Arg7 As Variant], [Arg8 As Variant], [Arg9 As Variant], [Arg10 As Variant], [Arg11 As Variant], [Arg12 As Variant], [Arg13 As Variant], [Arg14 As Variant], [Arg15 As Variant], [Arg16 As Variant], [Arg17 As Variant], [Arg18 As Variant], [Arg19 As Variant], [Arg20 As Variant], [Arg21 As Variant], [Arg22 As Variant], [Arg23 As Variant], [Arg24 As Variant], [Arg25 As Variant],[ Arg26 As Variant], [Arg27 As Variant], [Arg28 As Variant], [Arg29 As Variant], [Arg30 As Variant]) As Variant | ||||||||||
Mode_Snglメソッド | |||||||||||
説明 | 指定したデータの最頻値を返す | ||||||||||
定義 | Function Mode_Sngl(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, Arg7 As Variant, Arg8 As Variant, Arg9 As Variant, Arg10 As Variant, Arg11 As Variant, Arg12 As Variant, Arg13 As Variant, Arg14 As Variant, Arg15 As Variant, Arg16 As Variant, Arg17 As Variant, Arg18 As Variant, Arg19 As Variant, Arg20 As Variant, Arg21 As Variant, Arg22 As Variant, Arg23 As Variant, Arg24 As Variant, Arg25 As Variant, Arg26 As Variant, Arg27 As Variant, Arg28 As Variant, Arg29 As Variant, Arg30 As Variant) As Double | ||||||||||
MRoundメソッド | |||||||||||
説明 | 指定した値の倍数になるように数値を四捨五入する | ||||||||||
定義 | Function MRound(Arg1 As Variant, Arg2 As Variant) As Double | ||||||||||
MultiNomialメソッド | |||||||||||
説明 | 指定した複数の数値の多項係数を返す | ||||||||||
定義 | Function MultiNomial(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, Arg7 As Variant, Arg8 As Variant, Arg9 As Variant, Arg10 As Variant, Arg11 As Variant, Arg12 As Variant, Arg13 As Variant, Arg14 As Variant, Arg15 As Variant, Arg16 As Variant, Arg17 As Variant, Arg18 As Variant, Arg19 As Variant, Arg20 As Variant, Arg21 As Variant, Arg22 As Variant, Arg23 As Variant, Arg24 As Variant, Arg25 As Variant, Arg26 As Variant, Arg27 As Variant, Arg28 As Variant, Arg29 As Variant, Arg30 As Variant) As Double | ||||||||||
Munitメソッド | |||||||||||
説明 | 指定した次元の単位行列を返す | ||||||||||
定義 | Function Munit(Arg1 As Double) As Variant | ||||||||||
NegBinom_Distメソッド | |||||||||||
説明 | 負の二項分布の累積分布関数または確率密度関数の値を返す | ||||||||||
定義 | Function NegBinom_Dist(Arg1 As Double, Arg2 As Double, Arg3 As Double, [Arg4 As Boolean]) As Double | ||||||||||
NegBinomDistメソッド | |||||||||||
説明 | 負の二項分布の確率密度関数値を返す | ||||||||||
定義 | Function NegBinomDist(Arg1 As Double, Arg2 As Double, Arg3 As Double) As Double | ||||||||||
NetworkDaysメソッド | |||||||||||
説明 | 2つの日付間の稼働日の日数を返す | ||||||||||
定義 | Function NetworkDays(Arg1 As Variant, Arg2 As Variant, [Arg3 As Variant]) As Double | ||||||||||
NetworkDays_Intlメソッド | |||||||||||
説明 | 週末の曜日と日数を指定して、2つの日付間の稼働日の日数を返す | ||||||||||
定義 | Function NetworkDays_Intl(Arg1 As Variant, Arg2 As Variant, [Arg3 As Variant], [Arg4 As Variant]) As Double | ||||||||||
Nominalメソッド | |||||||||||
説明 | 名目年利率を返す | ||||||||||
定義 | Function Nominal(Arg1 As Variant, Arg2 As Variant) As Double | ||||||||||
Norm_Distメソッド | |||||||||||
説明 | 正規分布の累積分布関数または確率質量関数の値を返す | ||||||||||
定義 | Function Norm_Dist(Arg1 As Double, Arg2 As Double, Arg3 As Double, Arg4 As Boolean) As Double | ||||||||||
Norm_Invメソッド | |||||||||||
説明 | 正規分布の累積分布関数の逆関数値を返す | ||||||||||
定義 | Function Norm_Inv(Arg1 As Double, Arg2 As Double, Arg3 As Double) As Double | ||||||||||
Norm_S_Distメソッド | |||||||||||
説明 | 標準正規分布の累積分布関数の値を返す | ||||||||||
定義 | Function Norm_S_Dist(Arg1 As Double, [Arg2 As Boolean]) As Double | ||||||||||
Norm_S_Invメソッド | |||||||||||
説明 | 標準正規分布の累積分布関数の逆関数値を返す | ||||||||||
定義 | Function Norm_S_Inv(Arg1 As Double) As Double | ||||||||||
NormDistメソッド | |||||||||||
説明 | 正規分布の累積分布関数または確率質量関数の値を返す | ||||||||||
定義 | Function NormDist(Arg1 As Double, Arg2 As Double, Arg3 As Double, Arg4 As Boolean) As Double | ||||||||||
NormInvメソッド | |||||||||||
説明 | 正規分布の累積分布関数の逆関数値を返す | ||||||||||
定義 | Function NormInv(Arg1 As Double, Arg2 As Double, Arg3 As Double) As Double | ||||||||||
NormSDistメソッド | |||||||||||
説明 | 標準正規分布の累積分布関数の値を返す | ||||||||||
定義 | Function NormSDist(Arg1 As Double) As Double | ||||||||||
NormSInvメソッド | |||||||||||
説明 | 標準正規分布の累積分布関数の逆関数値を返す | ||||||||||
定義 | Function NormSInv(Arg1 As Double) As Double | ||||||||||
NPerメソッド | |||||||||||
説明 | 定額の支払いを定期的に行い、利率が一定であると仮定して、投資に必要な期間(支払回数)を返す | ||||||||||
定義 | Function NPer(Arg1 As Double, Arg2 As Double, Arg3 As Double, [Arg4 As Variant], [Arg5 As Variant]) As Double | ||||||||||
Npvメソッド | |||||||||||
説明 | 投資の正味現在価値を割引率や一連の支払いおよび収益を使って算出する | ||||||||||
定義 | Function Npv(Arg1 As Double, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, Arg7 As Variant, Arg8 As Variant, Arg9 As Variant, Arg10 As Variant, Arg11 As Variant, Arg12 As Variant, Arg13 As Variant, Arg14 As Variant, Arg15 As Variant, Arg16 As Variant, Arg17 As Variant, Arg18 As Variant, Arg19 As Variant, Arg20 As Variant, Arg21 As Variant, Arg22 As Variant, Arg23 As Variant, Arg24 As Variant, Arg25 As Variant, Arg26 As Variant, Arg27 As Variant, Arg28 As Variant, Arg29 As Variant, Arg30 As Variant) As Double | ||||||||||
NumberValueメソッド | |||||||||||
説明 | 文字列をロケールに依存しない方法で数値に変換する | ||||||||||
定義 | Function NumberValue(Arg1 As String, Arg2 As String, Arg3 As String) As Double | ||||||||||
Oct2Binメソッド | |||||||||||
説明 | 8進数を2進数に変換する | ||||||||||
定義 | Function Oct2Bin(Arg1 As Variant, [Arg2 As Variant]) As String | ||||||||||
Oct2Decメソッド | |||||||||||
説明 | 8進数を10進数に変換する | ||||||||||
定義 | Function Oct2Dec(Arg1 As Variant) As String | ||||||||||
Oct2Hexメソッド | |||||||||||
説明 | 8進数を16進数に変換する | ||||||||||
定義 | Function Oct2Hex(Arg1 As Variant, [Arg2 As Variant]) As String | ||||||||||
Oddメソッド | |||||||||||
説明 | 指定した数値を最も近い奇数に切り上げた値を返します | ||||||||||
定義 | Function Odd(Arg1 As Double) As Double | ||||||||||
OddFPriceメソッド | |||||||||||
説明 | 1期目の日数が半端な証券に対して、額面$100あたりの価格を返す | ||||||||||
定義 | Function OddFPrice(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, Arg7 As Variant, Arg8 As Variant, [Arg9 As Variant]) As Double | ||||||||||
OddFYieldメソッド | |||||||||||
説明 | 1期目の日数が半端な証券の利回りを返す | ||||||||||
定義 | Function OddFYield(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, Arg7 As Variant, Arg8 As Variant, [Arg9 As Variant]) As Double | ||||||||||
OddLPriceメソッド | |||||||||||
説明 | 最終期の日数が半端な証券に対して、額面$100あたりの価格を返す | ||||||||||
定義 | Function OddLPrice(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, Arg7 As Variant, [Arg8 As Variant]) As Double | ||||||||||
OddLYieldメソッド | |||||||||||
説明 | 最終期の日数が半端な証券の利回りを返す | ||||||||||
定義 | Function OddLYield(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, Arg7 As Variant, [Arg8 As Variant]) As Double | ||||||||||
Orメソッド | |||||||||||
説明 | 複数条件の論理和を返す | ||||||||||
定義 | Function Or(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, Arg7 As Variant, Arg8 As Variant, Arg9 As Variant, Arg10 As Variant, Arg11 As Variant, Arg12 As Variant, Arg13 As Variant, Arg14 As Variant, Arg15 As Variant, Arg16 As Variant, Arg17 As Variant, Arg18 As Variant, Arg19 As Variant, Arg20 As Variant, Arg21 As Variant, Arg22 As Variant, Arg23 As Variant, Arg24 As Variant, Arg25 As Variant, Arg26 As Variant, Arg27 As Variant, Arg28 As Variant, Arg29 As Variant, Arg30 As Variant) As Boolean | ||||||||||
PDurationメソッド | |||||||||||
説明 | 投資が指定した価値に達するまでの投資期間を返す | ||||||||||
定義 | Function PDuration(Arg1 As Double, Arg2 As Double, Arg3 As Double) As Double | ||||||||||
Pearsonメソッド | |||||||||||
説明 | ピアソンの積率相関係数rの値を返す | ||||||||||
定義 | Function Pearson(Arg1 As Variant, Arg2 As Variant) As Double | ||||||||||
Percentileメソッド | |||||||||||
説明 | 配列データの中で、百分率で率に位置する値を返す | ||||||||||
定義 | Function Percentile(Arg1 As Variant, Arg2 As Double) As Double | ||||||||||
Percentile_Excメソッド | |||||||||||
説明 | 配列データの中で、百分率で率に位置する値を返す | ||||||||||
定義 | Function Percentile_Exc(Arg1 As Variant, Arg2 As Double) As Double | ||||||||||
Percentile_Incメソッド | |||||||||||
説明 | 配列データの中で、百分率で率に位置する値を返す | ||||||||||
定義 | Function Percentile_Inc(Arg1 As Variant, Arg2 As Double) As Double | ||||||||||
PercentRankメソッド | |||||||||||
説明 | データセット内での値の順位を百分率で表した値を返す | ||||||||||
定義 | Function PercentRank(Arg1 As Variant, Arg2 As Double, [Arg3 As Variant]) As Double | ||||||||||
PercentRank_Excメソッド | |||||||||||
説明 | データセット内での値の順位を百分率で表した値を返す | ||||||||||
定義 | Function PercentRank_Exc(Arg1 As Variant, Arg2 As Double, [Arg3 As Variant]) As Double | ||||||||||
PercentRank_Incメソッド | |||||||||||
説明 | データセット内での値の順位を百分率で表した値を返す | ||||||||||
定義 | Function PercentRank_Inc(Arg1 As Variant, Arg2 As Double, [Arg3 As Variant]) As Double | ||||||||||
Permutメソッド | |||||||||||
説明 | 指定した個数を選択する時の順列の数を返す | ||||||||||
定義 | Function Permut(Arg1 As Double, Arg2 As Double) As Double | ||||||||||
Permutationaメソッド | |||||||||||
説明 | 全てのオブジェクトから指定された数のオブジェクト(繰り返しを含む)を選択する場合の順列の数を返す | ||||||||||
定義 | Function Permutationa(Arg1 As Double, Arg2 As Double) As Double | ||||||||||
Phiメソッド | |||||||||||
説明 | 標準正規分布の密度関数の値を返す | ||||||||||
定義 | Function Phi(Arg1 As Double) As Double | ||||||||||
Phoneticメソッド | |||||||||||
説明 | 文字列から振り仮名を抽出する | ||||||||||
定義 | Function Phonetic(Arg1 As Range) As String | ||||||||||
Piメソッド | |||||||||||
説明 | 円周率πの近似値を返す | ||||||||||
定義 | Function Pi() As Double | ||||||||||
Pmtメソッド | |||||||||||
説明 | 一定利率の支払いが定期的に行われる場合の、ローンの定期支払額を返す | ||||||||||
定義 | Function Pmt(Arg1 As Double, Arg2 As Double, Arg3 As Double, [Arg4 As Variant], [Arg5 As Variant]) As Double | ||||||||||
Poissonメソッド | |||||||||||
説明 | ポアソン分布の確率または累積確率を返す | ||||||||||
定義 | Function Poisson(Arg1 As Double, Arg2 As Double, Arg3 As Boolean) As Double | ||||||||||
Poisson_Distメソッド | |||||||||||
説明 | ポアソン分布の確率または累積確率を返す | ||||||||||
定義 | Function Poisson_Dist(Arg1 As Double, Arg2 As Double, Arg3 As Boolean) As Double | ||||||||||
Powerメソッド | |||||||||||
説明 | 数値のべき乗を返す | ||||||||||
定義 | Function Power(Arg1 As Double, Arg2 As Double) As Double | ||||||||||
Ppmtメソッド | |||||||||||
説明 | 定額の支払いを定期的に行い、利率が一定であると仮定して、投資の指定した期に支払われる元金を返す | ||||||||||
定義 | Function Ppmt(Arg1 As Double, Arg2 As Double, Arg3 As Double, Arg4 As Double, [Arg5 As Variant], [Arg6 As Variant]) As Double | ||||||||||
Priceメソッド | |||||||||||
説明 | 定期的に利息が支払われる証券に対して、額面$100あたりの価格を返す | ||||||||||
定義 | Function Price(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, [Arg7 As Variant]) As Double | ||||||||||
PriceDiscメソッド | |||||||||||
説明 | 割引証券の額面$100あたりの価格を返す | ||||||||||
定義 | Function PriceDisc(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, [Arg5 As Variant]) As Double | ||||||||||
PriceMatメソッド | |||||||||||
説明 | 満期日に利息が支払われる証券に対して、額面$100あたりの価格を返す | ||||||||||
定義 | Function PriceMat(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, [Arg6 As Variant]) As Double | ||||||||||
Probメソッド | |||||||||||
説明 | 指定した範囲に含まれる値が上限と下限との間に収まる確率を返す | ||||||||||
定義 | Function Prob(Arg1 As Variant, Arg2 As Variant, Arg3 As Double, [Arg4 As Variant]) As Double | ||||||||||
Productメソッド | |||||||||||
説明 | 指定したデータの積を返す | ||||||||||
定義 | Function Product(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, Arg7 As Variant, Arg8 As Variant, Arg9 As Variant, Arg10 As Variant, Arg11 As Variant, Arg12 As Variant, Arg13 As Variant, Arg14 As Variant, Arg15 As Variant, Arg16 As Variant, Arg17 As Variant, Arg18 As Variant, Arg19 As Variant, Arg20 As Variant, Arg21 As Variant, Arg22 As Variant, Arg23 As Variant, Arg24 As Variant, Arg25 As Variant, Arg26 As Variant, Arg27 As Variant, Arg28 As Variant, Arg29 As Variant, Arg30 As Variant) As Double | ||||||||||
Properメソッド | |||||||||||
説明 | 文字列に含まれる英単語の先頭文字だけを大文字に変換する | ||||||||||
定義 | Function Proper(Arg1 As String) As String | ||||||||||
Pvメソッド | |||||||||||
説明 | 投資の現在価値を返す | ||||||||||
定義 | Function Pv(Arg1 As Double, Arg2 As Double, Arg3 As Double, [Arg4 As Variant], [Arg5 As Variant]) As Double | ||||||||||
Quartileメソッド | |||||||||||
説明 | データセットの四分位数を返す | ||||||||||
定義 | Function Quartile(Arg1 As Variant, Arg2 As Double) As Double | ||||||||||
Quartile_Excメソッド | |||||||||||
説明 | データセットの四分位数を返す | ||||||||||
定義 | Function Quartile_Exc(Arg1 As Variant, Arg2 As Double) As Double | ||||||||||
Quartile_Incメソッド | |||||||||||
説明 | データセットの四分位数を返す | ||||||||||
定義 | Function Quartile_Inc(Arg1 As Variant, Arg2 As Double) As Double | ||||||||||
Quotientメソッド | |||||||||||
説明 | 除算の商の整数部を返す | ||||||||||
定義 | Function Quotient(Arg1 As Variant, Arg2 As Variant) As Double | ||||||||||
Radiansメソッド | |||||||||||
説明 | 度をラジアンに変換する | ||||||||||
定義 | Function Radians(Arg1 As Double) As Double | ||||||||||
RandBetweenメソッド | |||||||||||
説明 | 指定された範囲内の数値の乱数を返す | ||||||||||
定義 | Function RandBetween(Arg1 As Variant, Arg2 As Variant) As Double | ||||||||||
Rankメソッド | |||||||||||
説明 | 数値のリストの中で指定した数値の順位を返す | ||||||||||
定義 | Function Rank(Arg1 As Double, Arg2 As Range, [Arg3 As Variant]) As Double | ||||||||||
Rank_Avgメソッド | |||||||||||
説明 | 数値のリストの中で指定した数値の順位を返す | ||||||||||
定義 | Function Rank_Avg(Arg1 As Double, Arg2 As Range, [Arg3 As Variant]) As Double | ||||||||||
Rank_Eqメソッド | |||||||||||
説明 | 数値のリストの中で指定した数値の順位を返す | ||||||||||
定義 | Function Rank_Eq(Arg1 As Double, Arg2 As Range, [Arg3 As Variant]) As Double | ||||||||||
Rateメソッド | |||||||||||
説明 | 年間の投資金利を返す | ||||||||||
定義 | Function Rate(Arg1 As Double, Arg2 As Double, Arg3 As Double, [Arg4 As Variant], [Arg5 As Variant], [Arg6 As Variant]) As Double | ||||||||||
Receivedメソッド | |||||||||||
説明 | 全額投資された証券に対して、満期日に支払われる金額を返す | ||||||||||
定義 | Function Received(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, [Arg5 As Variant]) As Double | ||||||||||
Replaceメソッド | |||||||||||
説明 | テキスト内の文字を置き換える(1バイト文字セットで使用) | ||||||||||
定義 | Function Replace(Arg1 As String, Arg2 As Double, Arg3 As Double, Arg4 As String) As String | ||||||||||
ReplaceBメソッド | |||||||||||
説明 | テキスト内の文字を置き換える(2バイト文字セットで使用) | ||||||||||
定義 | Function ReplaceB(Arg1 As String, Arg2 As Double, Arg3 As Double, Arg4 As String) As String | ||||||||||
Reptメソッド | |||||||||||
説明 | テキストを指定した回数だけ繰り返す | ||||||||||
定義 | Function Rept(Arg1 As String, Arg2 As Double) As String | ||||||||||
Romanメソッド | |||||||||||
説明 | アラビア数字をローマ数字を表す文字列に変換する | ||||||||||
定義 | Function Roman(Arg1 As Double, [Arg2 As Variant]) As String | ||||||||||
Roundメソッド | |||||||||||
説明 | 数値を指定した桁数で四捨五入する | ||||||||||
定義 | Function Round(Arg1 As Double, Arg2 As Double) As Double | ||||||||||
RoundDownメソッド | |||||||||||
説明 | 数値を指定した桁数で切り捨てる | ||||||||||
定義 | Function RoundDown(Arg1 As Double, Arg2 As Double) As Double | ||||||||||
RoundUpメソッド | |||||||||||
説明 | 数値を指定した桁数で切り上げる | ||||||||||
定義 | Function RoundUp(Arg1 As Double, Arg2 As Double) As Double | ||||||||||
Rriメソッド | |||||||||||
説明 | 投資の成長に対する等価利率を返す | ||||||||||
定義 | Function Rri(Arg1 As Double, Arg2 As Double, Arg3 As Double) As Double | ||||||||||
RSqメソッド | |||||||||||
説明 | ピアソンの積率相関係数の2乗値を返す | ||||||||||
定義 | Function RSq(Arg1 As Variant, Arg2 As Variant) As Double | ||||||||||
RTDメソッド | |||||||||||
説明 | COMオートメーションに対応するプログラムからリアルタイムデータを受信する | ||||||||||
定義 | Function RTD(progID As Variant, server As Variant, topic1 As Variant, [topic2 As Variant], [topic3 As Variant], [topic4 As Variant], [topic5 As Variant], [topic6 As Variant], [topic7 As Variant], [topic8 As Variant], [topic9 As Variant], [topic10 As Variant], [topic11 As Variant], [topic12 As Variant], [topic13 As Variant], [topic14 As Variant], [topic15 As Variant], [topic16 As Variant], [topic17 As Variant], [topic18 As Variant], [topic19 As Variant], [topic20 As Variant], [topic21 As Variant], [topic22 As Variant], [topic23 As Variant], [topic24 As Variant], [topic25 As Variant], [topic26 As Variant], [topic27 As Variant], [topic28 As Variant]) As Variant | ||||||||||
Searchメソッド | |||||||||||
説明 | テキスト内の文字列を検索する(1バイト文字セットで使用) | ||||||||||
定義 | Function Search(Arg1 As String, Arg2 As String, [Arg3 As Variant]) As Double | ||||||||||
SearchBメソッド | |||||||||||
説明 | テキスト内の文字列を検索する(2バイト文字セットで使用) | ||||||||||
定義 | Function SearchB(Arg1 As String, Arg2 As String, [Arg3 As Variant]) As Double | ||||||||||
Secメソッド | |||||||||||
説明 | 角度の正割を返す | ||||||||||
定義 | Function Sec(Arg1 As Double) As Double | ||||||||||
Sechメソッド | |||||||||||
説明 | 角度の双曲線正割を返す | ||||||||||
定義 | Function Sech(Arg1 As Double) As Double | ||||||||||
SeriesSumメソッド | |||||||||||
説明 | べき級数の和を返す | ||||||||||
定義 | Function SeriesSum(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant) As Double | ||||||||||
Sinhメソッド | |||||||||||
説明 | 数値の双曲線正弦を返す | ||||||||||
定義 | Function Sinh(Arg1 As Double) As Double | ||||||||||
Skewメソッド | |||||||||||
説明 | データセットの歪度を返す | ||||||||||
定義 | Function Skew(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, Arg7 As Variant, Arg8 As Variant, Arg9 As Variant, Arg10 As Variant, Arg11 As Variant, Arg12 As Variant, Arg13 As Variant, Arg14 As Variant, Arg15 As Variant, Arg16 As Variant, Arg17 As Variant, Arg18 As Variant, Arg19 As Variant, Arg20 As Variant, Arg21 As Variant, Arg22 As Variant, Arg23 As Variant, Arg24 As Variant, Arg25 As Variant, Arg26 As Variant, Arg27 As Variant, Arg28 As Variant, Arg29 As Variant, Arg30 As Variant) As Double | ||||||||||
Skew_pメソッド | |||||||||||
説明 | 母集団に基づく分布の歪度を返す | ||||||||||
定義 | Function Skew_p(Arg1 As Variant, [Arg2 As Variant], [Arg3 As Variant], [Arg4 As Variant], [Arg5 As Variant], [Arg6 As Variant], [Arg7 As Variant], [Arg8 As Variant], [Arg9 As Variant], [Arg10 As Variant], [Arg11 As Variant], [Arg12 As Variant], [Arg13 As Variant], [Arg14 As Variant], [Arg15 As Variant], [Arg16 As Variant], [Arg17 As Variant], [Arg18 As Variant], [Arg19 As Variant], [Arg20 As Variant], [Arg21 As Variant], [Arg22 As Variant], [Arg23 As Variant], [Arg24 As Variant], [Arg25 As Variant],[ Arg26 As Variant], [Arg27 As Variant], [Arg28 As Variant], [Arg29 As Variant], [Arg30 As Variant]) As Double | ||||||||||
Slnメソッド | |||||||||||
説明 | 数値の正弦を返す | ||||||||||
定義 | Function Sln(Arg1 As Double, Arg2 As Double, Arg3 As Double) As Double | ||||||||||
Slopeメソッド | |||||||||||
説明 | 回帰直線の傾きを返す | ||||||||||
定義 | Function Slope(Arg1 As Variant, Arg2 As Variant) As Double | ||||||||||
Smallメソッド | |||||||||||
説明 | 1つのデータセットの中で’順位’番目に小さなデータを返す | ||||||||||
定義 | Function Small(Arg1 As Variant, Arg2 As Double) As Double | ||||||||||
SqrtPiメソッド | |||||||||||
説明 | (数値*π)の平方根を返す | ||||||||||
定義 | Function SqrtPi(Arg1 As Variant) As Double | ||||||||||
Standardizeメソッド | |||||||||||
説明 | 正規化された値を返す | ||||||||||
定義 | Function Standardize(Arg1 As Double, Arg2 As Double, Arg3 As Double) As Double | ||||||||||
StDevメソッド | |||||||||||
説明 | データセットを標本とみなして推定した母集団の標準偏差を返す | ||||||||||
定義 | Function StDev(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, Arg7 As Variant, Arg8 As Variant, Arg9 As Variant, Arg10 As Variant, Arg11 As Variant, Arg12 As Variant, Arg13 As Variant, Arg14 As Variant, Arg15 As Variant, Arg16 As Variant, Arg17 As Variant, Arg18 As Variant, Arg19 As Variant, Arg20 As Variant, Arg21 As Variant, Arg22 As Variant, Arg23 As Variant, Arg24 As Variant, Arg25 As Variant, Arg26 As Variant, Arg27 As Variant, Arg28 As Variant, Arg29 As Variant, Arg30 As Variant) As Double | ||||||||||
StDev_Pメソッド | |||||||||||
説明 | データセットを母集団全体とみなして算出した標準偏差を返す | ||||||||||
定義 | Function StDev_P(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, Arg7 As Variant, Arg8 As Variant, Arg9 As Variant, Arg10 As Variant, Arg11 As Variant, Arg12 As Variant, Arg13 As Variant, Arg14 As Variant, Arg15 As Variant, Arg16 As Variant, Arg17 As Variant, Arg18 As Variant, Arg19 As Variant, Arg20 As Variant, Arg21 As Variant, Arg22 As Variant, Arg23 As Variant, Arg24 As Variant, Arg25 As Variant, Arg26 As Variant, Arg27 As Variant, Arg28 As Variant, Arg29 As Variant, Arg30 As Variant) As Double | ||||||||||
StDev_Sメソッド | |||||||||||
説明 | データセットを標本とみなして推定した母集団の標準偏差を返す | ||||||||||
定義 | Function StDev_S(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, Arg7 As Variant, Arg8 As Variant, Arg9 As Variant, Arg10 As Variant, Arg11 As Variant, Arg12 As Variant, Arg13 As Variant, Arg14 As Variant, Arg15 As Variant, Arg16 As Variant, Arg17 As Variant, Arg18 As Variant, Arg19 As Variant, Arg20 As Variant, Arg21 As Variant, Arg22 As Variant, Arg23 As Variant, Arg24 As Variant, Arg25 As Variant, Arg26 As Variant, Arg27 As Variant, Arg28 As Variant, Arg29 As Variant, Arg30 As Variant) As Double | ||||||||||
StDevPメソッド | |||||||||||
説明 | データセットを母集団全体とみなして算出した標準偏差を返す | ||||||||||
定義 | Function StDevP(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, Arg7 As Variant, Arg8 As Variant, Arg9 As Variant, Arg10 As Variant, Arg11 As Variant, Arg12 As Variant, Arg13 As Variant, Arg14 As Variant, Arg15 As Variant, Arg16 As Variant, Arg17 As Variant, Arg18 As Variant, Arg19 As Variant, Arg20 As Variant, Arg21 As Variant, Arg22 As Variant, Arg23 As Variant, Arg24 As Variant, Arg25 As Variant, Arg26 As Variant, Arg27 As Variant, Arg28 As Variant, Arg29 As Variant, Arg30 As Variant) As Double | ||||||||||
StEyxメソッド | |||||||||||
説明 | 回帰直線上の予測値の標準誤差を返す | ||||||||||
定義 | Function StEyx(Arg1 As Variant, Arg2 As Variant) As Double | ||||||||||
Substituteメソッド | |||||||||||
説明 | 文字列中の指定した文字を他の新しい文字に置き換える | ||||||||||
定義 | Function Substitute(Arg1 As String, Arg2 As String, Arg3 As String, [Arg4 As Variant]) As String | ||||||||||
Subtotalメソッド | |||||||||||
説明 | リストまたはデータベースの集計値を返す | ||||||||||
定義 | Function Subtotal(Arg1 As Variant, Arg2 As Variant, [Arg3 As Variant], [Arg4 As Variant], [Arg5 As Variant], [Arg6 As Variant], [Arg7 As Variant], [Arg8 As Variant], [Arg9 As Variant], [Arg10 As Variant], [Arg11 As Variant], [Arg12 As Variant], [Arg13 As Variant], [Arg14 As Variant], [Arg15 As Variant], [Arg16 As Variant], [Arg17 As Variant], [Arg18 As Variant], [Arg19 As Variant], [Arg20 As Variant], [Arg21 As Variant], [Arg22 As Variant], [Arg23 As Variant], [Arg24 As Variant], [Arg25 As Variant],[ Arg26 As Variant], [Arg27 As Variant], [Arg28 As Variant], [Arg29 As Variant], [Arg30 As Variant]) As Double | ||||||||||
Sumメソッド | |||||||||||
説明 | 指定したデータに含まれる数値を合計する | ||||||||||
定義 | Function Sum(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, Arg7 As Variant, Arg8 As Variant, Arg9 As Variant, Arg10 As Variant, Arg11 As Variant, Arg12 As Variant, Arg13 As Variant, Arg14 As Variant, Arg15 As Variant, Arg16 As Variant, Arg17 As Variant, Arg18 As Variant, Arg19 As Variant, Arg20 As Variant, Arg21 As Variant, Arg22 As Variant, Arg23 As Variant, Arg24 As Variant, Arg25 As Variant, Arg26 As Variant, Arg27 As Variant, Arg28 As Variant, Arg29 As Variant, Arg30 As Variant) As Double | ||||||||||
SumIfメソッド | |||||||||||
説明 | 指定した範囲に含まれるセルのうち、検索条件に一致するセルの値を合計する | ||||||||||
定義 | Function SumIf(Arg1 As Range, Arg2 As Variant, [Arg3 As Variant]) As Double | ||||||||||
SumIfsメソッド | |||||||||||
説明 | 指定した範囲に含まれるセルのうち、複数の検索条件に一致するセルの値を合計する | ||||||||||
定義 | Function SumIfs(Arg1 As Range, Arg2 As Range, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, Arg7 As Variant, Arg8 As Variant, Arg9 As Variant, Arg10 As Variant, Arg11 As Variant, Arg12 As Variant, Arg13 As Variant, Arg14 As Variant, Arg15 As Variant, Arg16 As Variant, Arg17 As Variant, Arg18 As Variant, Arg19 As Variant, Arg20 As Variant, Arg21 As Variant, Arg22 As Variant, Arg23 As Variant, Arg24 As Variant, Arg25 As Variant, Arg26 As Variant, Arg27 As Variant, Arg28 As Variant, Arg29 As Variant) As Double | ||||||||||
SumProductメソッド | |||||||||||
説明 | 指定した配列で対応する要素の積を合計する | ||||||||||
定義 | Function SumProduct(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, Arg7 As Variant, Arg8 As Variant, Arg9 As Variant, Arg10 As Variant, Arg11 As Variant, Arg12 As Variant, Arg13 As Variant, Arg14 As Variant, Arg15 As Variant, Arg16 As Variant, Arg17 As Variant, Arg18 As Variant, Arg19 As Variant, Arg20 As Variant, Arg21 As Variant, Arg22 As Variant, Arg23 As Variant, Arg24 As Variant, Arg25 As Variant, Arg26 As Variant, Arg27 As Variant, Arg28 As Variant, Arg29 As Variant, Arg30 As Variant) As Double | ||||||||||
SumSqメソッド | |||||||||||
説明 | 指定したデータの平方和を返す | ||||||||||
定義 | Function SumSq(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, Arg7 As Variant, Arg8 As Variant, Arg9 As Variant, Arg10 As Variant, Arg11 As Variant, Arg12 As Variant, Arg13 As Variant, Arg14 As Variant, Arg15 As Variant, Arg16 As Variant, Arg17 As Variant, Arg18 As Variant, Arg19 As Variant, Arg20 As Variant, Arg21 As Variant, Arg22 As Variant, Arg23 As Variant, Arg24 As Variant, Arg25 As Variant, Arg26 As Variant, Arg27 As Variant, Arg28 As Variant, Arg29 As Variant, Arg30 As Variant) As Double | ||||||||||
SumX2MY2メソッド | |||||||||||
説明 | 2つの配列で対応する配列要素の平方差を合計する | ||||||||||
定義 | Function SumX2MY2(Arg1 As Variant, Arg2 As Variant) As Double | ||||||||||
SumX2PY2メソッド | |||||||||||
説明 | 2つの配列で対応する配列要素の平方和を合計する | ||||||||||
定義 | Function SumX2PY2(Arg1 As Variant, Arg2 As Variant) As Double | ||||||||||
SumXMY2メソッド | |||||||||||
説明 | 2つの配列で対応する配列要素の差を2乗して合計する | ||||||||||
定義 | Function SumXMY2(Arg1 As Variant, Arg2 As Variant) As Double | ||||||||||
Sydメソッド | |||||||||||
説明 | 級数法を使用して、特定の期における減価償却費を返す | ||||||||||
定義 | Function Syd(Arg1 As Double, Arg2 As Double, Arg3 As Double, Arg4 As Double) As Double | ||||||||||
T_Distメソッド | |||||||||||
説明 | スチューデントのt分布の確率密度関数の値を返す | ||||||||||
定義 | Function T_Dist(Arg1 As Double, Arg2 As Double, Arg3 As Boolean) As Double | ||||||||||
T_Dist_2Tメソッド | |||||||||||
説明 | スチューデントのt分布の両側確率密度関数の値を返す | ||||||||||
定義 | Function T_Dist_2T(Arg1 As Double, Arg2 As Double) As Double | ||||||||||
T_Dist_RTメソッド | |||||||||||
説明 | スチューデントのt分布の右側確率密度関数の値を返す | ||||||||||
定義 | Function T_Dist_RT(Arg1 As Double, Arg2 As Double) As Double | ||||||||||
T_Invメソッド | |||||||||||
説明 | スチューデントのt分布の左側逆関数の値を返す(指定した確率と自由度からt値を求める際に使用) | ||||||||||
定義 | Function T_Inv(Arg1 As Double, Arg2 As Double) As Double | ||||||||||
T_Inv_2Tメソッド | |||||||||||
説明 | スチューデントのt分布の両側逆関数の値を返す(指定した確率と自由度からt値を求める際に使用) | ||||||||||
定義 | Function T_Inv_2T(Arg1 As Double, Arg2 As Double) As Double | ||||||||||
T_Testメソッド | |||||||||||
説明 | スチューデントのt検定の結果を返す | ||||||||||
定義 | Function T_Test(Arg1 As Variant, Arg2 As Variant, Arg3 As Double, Arg4 As Double) As Double | ||||||||||
Tanhメソッド | |||||||||||
説明 | 数値の双曲線正接を返す | ||||||||||
定義 | Function Tanh(Arg1 As Double) As Double | ||||||||||
TBillEqメソッド | |||||||||||
説明 | 米国財務省短期証券(TB)の債券換算利回りを返す | ||||||||||
定義 | Function TBillEq(Arg1 As Variant, Arg2 As Variant, [Arg3 As Variant]) As Double | ||||||||||
TBillPriceメソッド | |||||||||||
説明 | 米国財務省短期証券(TB)の額面$100あたりの価格を返す | ||||||||||
定義 | Function TBillPrice(Arg1 As Variant, Arg2 As Variant, [Arg3 As Variant]) As Double | ||||||||||
TBillYieldメソッド | |||||||||||
説明 | 米国財務省短期証券(TB)の利回りを返す | ||||||||||
定義 | Function TBillYield(Arg1 As Variant, Arg2 As Variant, [Arg3 As Variant]) As Double | ||||||||||
TDistメソッド | |||||||||||
説明 | スチューデントのt分布の確率密度関数の値を返す | ||||||||||
定義 | Function TDist(Arg1 As Double, Arg2 As Double, Arg3 As Double) As Double | ||||||||||
Textメソッド | |||||||||||
説明 | 数値を書式設定したテキストに変換する | ||||||||||
定義 | Function Text(Arg1 As Variant, Arg2 As String) As String | ||||||||||
TInvメソッド | |||||||||||
説明 | スチューデントのt分布の左側逆関数の値を返す(指定した確率と自由度からt値を求める際に使用) | ||||||||||
定義 | Function TInv(Arg1 As Double, Arg2 As Double) As Double | ||||||||||
Transposeメソッド | |||||||||||
説明 | 指定したセル範囲のデータの行と列を入れ替えた配列を返す | ||||||||||
定義 | Function Transpose(Arg1 As Variant) As Variant | ||||||||||
Trendメソッド | |||||||||||
説明 | 回帰直線による予測値を配列で返す | ||||||||||
定義 | Function Trend(Arg1 As Variant, [Arg2 As Variant], [Arg3 As Variant], [Arg4 As Variant]) As Variant | ||||||||||
Trimメソッド | |||||||||||
説明 | テキストからスペースを削除する
(※)文字列内に複数のスペースが連続している場合、スペースを1つずつ残す |
||||||||||
定義 | Function Trim(Arg1 As String) As String | ||||||||||
TrimMeanメソッド | |||||||||||
説明 | データ セットの中間項の平均を返す | ||||||||||
定義 | Function TrimMean(Arg1 As Variant, Arg2 As Double) As Double | ||||||||||
TTestメソッド | |||||||||||
説明 | スチューデントのt検定の結果を返す | ||||||||||
定義 | Function TTest(Arg1 As Variant, Arg2 As Variant, Arg3 As Double, Arg4 As Double) As Double | ||||||||||
Unicharメソッド | |||||||||||
説明 | 指定した数値に対応するUnicode文字を返す | ||||||||||
定義 | Function Unichar(Arg1 As Double) As String | ||||||||||
Unicodeメソッド | |||||||||||
説明 | 文字列の先頭の文字に対応する文字コードを返す | ||||||||||
定義 | Function Unicode(Arg1 As String) As Double | ||||||||||
USDollarメソッド | |||||||||||
説明 | ドル($)通貨書式を使用して数値を文字列に変換する | ||||||||||
定義 | Function USDollar(Arg1 As Double, Arg2 As Double) As String | ||||||||||
Varメソッド | |||||||||||
説明 | データセットを標本とみなして推定した母集団の分散を返す | ||||||||||
定義 | Function Var(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, Arg7 As Variant, Arg8 As Variant, Arg9 As Variant, Arg10 As Variant, Arg11 As Variant, Arg12 As Variant, Arg13 As Variant, Arg14 As Variant, Arg15 As Variant, Arg16 As Variant, Arg17 As Variant, Arg18 As Variant, Arg19 As Variant, Arg20 As Variant, Arg21 As Variant, Arg22 As Variant, Arg23 As Variant, Arg24 As Variant, Arg25 As Variant, Arg26 As Variant, Arg27 As Variant, Arg28 As Variant, Arg29 As Variant, Arg30 As Variant) As Double | ||||||||||
Var_Pメソッド | |||||||||||
説明 | データセットを母集団全体とみなして算出した分散を返す | ||||||||||
定義 | Function Var_P(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, Arg7 As Variant, Arg8 As Variant, Arg9 As Variant, Arg10 As Variant, Arg11 As Variant, Arg12 As Variant, Arg13 As Variant, Arg14 As Variant, Arg15 As Variant, Arg16 As Variant, Arg17 As Variant, Arg18 As Variant, Arg19 As Variant, Arg20 As Variant, Arg21 As Variant, Arg22 As Variant, Arg23 As Variant, Arg24 As Variant, Arg25 As Variant, Arg26 As Variant, Arg27 As Variant, Arg28 As Variant, Arg29 As Variant, Arg30 As Variant) As Double | ||||||||||
Var_Sメソッド | |||||||||||
説明 | データセットを標本とみなして推定した母集団の分散を返す | ||||||||||
定義 | Function Var_S(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, Arg7 As Variant, Arg8 As Variant, Arg9 As Variant, Arg10 As Variant, Arg11 As Variant, Arg12 As Variant, Arg13 As Variant, Arg14 As Variant, Arg15 As Variant, Arg16 As Variant, Arg17 As Variant, Arg18 As Variant, Arg19 As Variant, Arg20 As Variant, Arg21 As Variant, Arg22 As Variant, Arg23 As Variant, Arg24 As Variant, Arg25 As Variant, Arg26 As Variant, Arg27 As Variant, Arg28 As Variant, Arg29 As Variant, Arg30 As Variant) As Double | ||||||||||
VarPメソッド | |||||||||||
説明 | データセットを母集団全体とみなして算出した分散を返す | ||||||||||
定義 | Function VarP(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, Arg6 As Variant, Arg7 As Variant, Arg8 As Variant, Arg9 As Variant, Arg10 As Variant, Arg11 As Variant, Arg12 As Variant, Arg13 As Variant, Arg14 As Variant, Arg15 As Variant, Arg16 As Variant, Arg17 As Variant, Arg18 As Variant, Arg19 As Variant, Arg20 As Variant, Arg21 As Variant, Arg22 As Variant, Arg23 As Variant, Arg24 As Variant, Arg25 As Variant, Arg26 As Variant, Arg27 As Variant, Arg28 As Variant, Arg29 As Variant, Arg30 As Variant) As Double | ||||||||||
Vdbメソッド | |||||||||||
説明 | 定率法を利用して、特定の期または部分的な期における資産の減価償却費を返す | ||||||||||
定義 | Function Vdb(Arg1 As Double, Arg2 As Double, Arg3 As Double, Arg4 As Double, Arg5 As Double, [Arg6 As Variant], [Arg7 As Variant]) As Double | ||||||||||
VLookupメソッド | |||||||||||
説明 | 配列の左端列で特定の値を検索し、対応するセルの値を返す | ||||||||||
定義 | Function VLookup(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, [Arg4 As Variant]) As Variant | ||||||||||
WebServiceメソッド | |||||||||||
説明 | HTTP GET要求を使用してWebサービスを非同期で呼び出し、データを取得する | ||||||||||
定義 | Function WebService(Arg1 As String) As Variant | ||||||||||
Weekdayメソッド | |||||||||||
説明 | 指定した日付に対応する曜日を返す | ||||||||||
定義 | Function Weekday(Arg1 As Variant, [Arg2 As Variant]) As Double | ||||||||||
WeekNumメソッド | |||||||||||
説明 | 指定した日付に対応する週番号を返す | ||||||||||
定義 | Function WeekNum(Arg1 As Variant, [Arg2 As Variant]) As Double | ||||||||||
Weibullメソッド | |||||||||||
説明 | ワイブル分布の確率密度関数の値を返す | ||||||||||
定義 | Function Weibull(Arg1 As Double, Arg2 As Double, Arg3 As Double, Arg4 As Boolean) As Double | ||||||||||
Weibull_Distメソッド | |||||||||||
説明 | ワイブル分布の確率密度関数の値を返す | ||||||||||
定義 | Function Weibull_Dist(Arg1 As Double, Arg2 As Double, Arg3 As Double, Arg4 As Boolean) As Double | ||||||||||
WorkDayメソッド | |||||||||||
説明 | 指定した稼動日数だけ前または後の日付に対応するシリアル値を返す | ||||||||||
定義 | Function WorkDay(Arg1 As Variant, Arg2 As Variant, [Arg3 As Variant]) As Double | ||||||||||
WorkDay_Intlメソッド | |||||||||||
説明 | 週末の曜日と日数を指定して、指定した稼働日数だけ前または後の日付に対応するシリアル値を返す | ||||||||||
定義 | Function WorkDay_Intl(Arg1 As Variant, Arg2 As Variant, [Arg3 As Variant], [Arg4 As Variant]) As Double | ||||||||||
Xirrメソッド | |||||||||||
説明 | 定期的でないキャッシュフローに対する内部利益率を返す | ||||||||||
定義 | Function Xirr(Arg1 As Variant, Arg2 As Variant, [Arg3 As Variant]) As Double | ||||||||||
Xnpvメソッド | |||||||||||
説明 | 定期的でないキャッシュフローの特定のスケジュールに対する正味現在価値を返す | ||||||||||
定義 | Function Xnpv(Arg1 As Variant, Arg2 As Variant) As Double | ||||||||||
Xorメソッド | |||||||||||
説明 | 複数条件の排他的論理和を返す | ||||||||||
定義 | Function Xor(Arg1 As Variant, [Arg2 As Variant], [Arg3 As Variant], [Arg4 As Variant], [Arg5 As Variant], [Arg6 As Variant], [Arg7 As Variant], [Arg8 As Variant], [Arg9 As Variant], [Arg10 As Variant], [Arg11 As Variant], [Arg12 As Variant], [Arg13 As Variant], [Arg14 As Variant], [Arg15 As Variant], [Arg16 As Variant], [Arg17 As Variant], [Arg18 As Variant], [Arg19 As Variant], [Arg20 As Variant], [Arg21 As Variant], [Arg22 As Variant], [Arg23 As Variant], [Arg24 As Variant], [Arg25 As Variant],[ Arg26 As Variant], [Arg27 As Variant], [Arg28 As Variant], [Arg29 As Variant], [Arg30 As Variant]) As Boolean | ||||||||||
YearFracメソッド | |||||||||||
説明 | 開始日と終了日を指定して、その期間が1年間に対して占める割合を返す | ||||||||||
定義 | Function YearFrac(Arg1 As Variant, Arg2 As Variant, [Arg3 As Variant]) As Double | ||||||||||
YieldDiscメソッド | |||||||||||
説明 | 割引債の年利回りを返す | ||||||||||
定義 | Function YieldDisc(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, [Arg5 As Variant]) As Double | ||||||||||
YieldMatメソッド | |||||||||||
説明 | 満期日に利息が支払われる証券の利回りを返す | ||||||||||
定義 | Function YieldMat(Arg1 As Variant, Arg2 As Variant, Arg3 As Variant, Arg4 As Variant, Arg5 As Variant, [Arg6 As Variant]) As Double | ||||||||||
Z_Testメソッド | |||||||||||
説明 | z検定の片側確率の値を返す | ||||||||||
定義 | Function Z_Test(Arg1 As Variant, Arg2 As Double, [Arg3 As Variant]) As Double | ||||||||||
ZTestメソッド | |||||||||||
説明 | z検定の片側確率の値を返す | ||||||||||
定義 | Function ZTest(Arg1 As Variant, Arg2 As Double, [Arg3 As Variant]) As Double |
WorksheetFunctionオブジェクトのプロパティ
Applicationプロパティ(読み取り専用) | |||||||||||
説明 | オブジェクトを作成したアプリケーションを表すApplicationオブジェクトを取得 | ||||||||||
定義 | Property Application() As Application | ||||||||||
Creatorプロパティ(読み取り専用) | |||||||||||
説明 | オブジェクトを作成したアプリケーションの整数値を取得
(※)XlCreator列挙体は、以下の値のみ。 |
||||||||||
定義 | Property Creator() As XlCreator | ||||||||||
Parentプロパティ(読み取り専用) | |||||||||||
説明 | 指定されたオブジェクトの親オブジェクトを取得 | ||||||||||
定義 | Property Parent() As Object |
国本温子(著),緑川吉行(著),できるシリーズ編集部(著)
出版社:インプレス
発売日:2022/3/23
単行本(ソフトカバー):A5判/912ページ
出版社:インプレス
発売日:2022/3/23
単行本(ソフトカバー):A5判/912ページ
大村あつし(著),古川順平(著)
出版社:技術評論社
発売日:2021/1/9
単行本(ソフトカバー):A5判/800ページ
出版社:技術評論社
発売日:2021/1/9
単行本(ソフトカバー):A5判/800ページ
高橋宣成(著)
出版社:技術評論社
発売日:2019/11/25
単行本(ソフトカバー):B5変形判/576ページ
出版社:技術評論社
発売日:2019/11/25
単行本(ソフトカバー):B5変形判/576ページ
ディスカッション
コメント一覧
まだ、コメントがありません