Visual Basic で使用できるワークシート関数一覧List of worksheet functions available to Visual Basic

次の一覧は、WorkSheetFunction オブジェクトを使用して呼び出せるすべてのワークシート関数を示しています。The following list represents all of the worksheet functions that can be called using the WorkSheetFunction object.

特定の関数の詳細については、「 Excel の関数 (カテゴリ別) 」トピックを参照してください。For more information about a particular function, see the Excel functions (by category) topic.

  • AccrIntAccrInt
  • AccrIntMAccrIntM
  • AcosAcos
  • AcoshAcosh
  • AggregateAggregate
  • AmorDegrcAmorDegrc
  • AmorLincAmorLinc
  • AndAnd
  • ApplicationApplication
  • AscAsc
  • AsinAsin
  • AsinhAsinh
  • Atan2Atan2
  • AtanhAtanh
  • AveDevAveDev
  • AverageAverage
  • AverageIfAverageIf
  • AverageIfsAverageIfs
  • BahtTextBahtText
  • BesselIBesselI
  • BesselJBesselJ
  • BesselKBesselK
  • BesselYBesselY
  • BetaDistBetaDist
  • BetaInvBetaInv
  • Bin2DecBin2Dec
  • Bin2HexBin2Hex
  • Bin2OctBin2Oct
  • Binom_DistBinom_Dist
  • Binom_InvBinom_Inv
  • BinomDistBinomDist
  • CeilingCeiling
  • Ceiling_PreciseCeiling_Precise
  • ChiDistChiDist
  • ChiInvChiInv
  • ChiSq_DistChiSq_Dist
  • ChiSq_Dist_RTChiSq_Dist_RT
  • ChiSq_InvChiSq_Inv
  • ChiSq_Inv_RTChiSq_Inv_RT
  • ChiSq_TestChiSq_Test
  • ChiTestChiTest
  • ChooseChoose
  • CleanClean
  • CombinCombin
  • 複雑Complex
  • ConfidenceConfidence
  • Confidence_NormConfidence_Norm
  • Confidence_TConfidence_T
  • ConvertConvert
  • CorrelCorrel
  • CoshCosh
  • カウントCount
  • CountACountA
  • CountBlankCountBlank
  • CountIfCountIf
  • CountIfsCountIfs
  • CoupDayBsCoupDayBs
  • CoupDaysCoupDays
  • CoupDaysNcCoupDaysNc
  • CoupNcdCoupNcd
  • CoupNumCoupNum
  • CoupPcdCoupPcd
  • CovarCovar
  • Covariance_PCovariance_P
  • Covariance_SCovariance_S
  • CritBinomCritBinom
  • CumIPmtCumIPmt
  • CumPrincCumPrinc
  • DAverageDAverage
  • Days360Days360
  • DbDb
  • DbcsDbcs
  • DCountDCount
  • DCountADCountA
  • DdbDdb
  • Dec2BinDec2Bin
  • Dec2HexDec2Hex
  • Dec2OctDec2Oct
  • 学位Degrees
  • DeltaDelta
  • DevSqDevSq
  • DGetDGet
  • DiscDisc
  • DMaxDMax
  • DMinDMin
  • DollarDollar
  • DollarDeDollarDe
  • DollarFrDollarFr
  • DProductDProduct
  • DStDevDStDev
  • DStDevPDStDevP
  • DSumDSum
  • DurationDuration
  • DVarDVar
  • DVarPDVarP
  • EDateEDate
  • 効果Effect
  • EoMonthEoMonth
  • ErfErf
  • Erf_PreciseErf_Precise
  • ErfCErfC
  • EvenEven
  • Expon_DistExpon_Dist
  • ExponDistExponDist
  • F_DistF_Dist
  • F_Dist_RTF_Dist_RT
  • F_InvF_Inv
  • F_Inv_RTF_Inv_RT
  • F_TestF_Test
  • FactFact
  • FactDoubleFactDouble
  • FDistFDist
  • 検索Find
  • FindBFindB
  • FInvFInv
  • FisherFisher
  • FisherInvFisherInv
  • FixedFixed
  • FloorFloor
  • ForecastForecast
  • FrequencyFrequency
  • FTestFTest
  • FvFv
  • FVScheduleFVSchedule
  • Gamma_DistGamma_Dist
  • Gamma_InvGamma_Inv
  • GammaDistGammaDist
  • GammaInvGammaInv
  • GammaLnGammaLn
  • GammaLn_PreciseGammaLn_Precise
  • GcdGcd
  • GeoMeanGeoMean
  • GeStepGeStep
  • GrowthGrowth
  • HarMeanHarMean
  • Hex2BinHex2Bin
  • Hex2DecHex2Dec
  • Hex2OctHex2Oct
  • HLookupHLookup
  • HypGeom_DistHypGeom_Dist
  • HypGeomDistHypGeomDist
  • IfErrorIfError
  • ImAbsImAbs
  • ImaginaryImaginary
  • ImArgumentImArgument
  • ImConjugateImConjugate
  • ImCosImCos
  • ImDivImDiv
  • ImExpImExp
  • ImLnImLn
  • ImLog10ImLog10
  • ImLog2ImLog2
  • ImPowerImPower
  • ImProductImProduct
  • ImRealImReal
  • ImSinImSin
  • ImSqrtImSqrt
  • ImSubImSub
  • ImSumImSum
  • IndexIndex
  • InterceptIntercept
  • IntRateIntRate
  • IpmtIpmt
  • IrrIrr
  • IsErrIsErr
  • IsErrorIsError
  • IsEvenIsEven
  • IsLogicalIsLogical
  • IsNAIsNA
  • IsNonTextIsNonText
  • IsNumberIsNumber
  • IsOddIsOdd
  • IspmtIspmt
  • IsTextIsText
  • KurtKurt
  • LargeLarge
  • LcmLcm
  • LinEstLinEst
  • LnLn
  • LogLog
  • Log10Log10
  • LogEstLogEst
  • LogInvLogInv
  • LogNorm_DistLogNorm_Dist
  • LogNorm_InvLogNorm_Inv
  • LogNormDistLogNormDist
  • LookupLookup
  • MatchMatch
  • MaxMax
  • MDetermMDeterm
  • MDurationMDuration
  • MedianMedian
  • MinMin
  • MInverseMInverse
  • MIrrMIrr
  • MMultMMult
  • ModeMode
  • Mode_MultMode_Mult
  • Mode_SnglMode_Sngl
  • MRoundMRound
  • MultiNomialMultiNomial
  • NegBinom_DistNegBinom_Dist
  • NegBinomDistNegBinomDist
  • NetworkDaysNetworkDays
  • NominalNominal
  • Norm_DistNorm_Dist
  • Norm_InvNorm_Inv
  • Norm_S_DistNorm_S_Dist
  • Norm_S_InvNorm_S_Inv
  • NormDistNormDist
  • NormInvNormInv
  • NormSDistNormSDist
  • NormSInvNormSInv
  • NPerNPer
  • NpvNpv
  • Oct2BinOct2Bin
  • Oct2DecOct2Dec
  • Oct2HexOct2Hex
  • OddOdd
  • OddFPriceOddFPrice
  • OddFYieldOddFYield
  • OddLPriceOddLPrice
  • OddLYieldOddLYield
  • またはOr
  • PearsonPearson
  • PercentilePercentile
  • Percentile_ExcPercentile_Exc
  • Percentile_IncPercentile_Inc
  • PercentRankPercentRank
  • PercentRank_ExcPercentRank_Exc
  • PercentRank_IncPercentRank_Inc
  • PermutPermut
  • PhoneticPhonetic
  • PiPi
  • PmtPmt
  • PoissonPoisson
  • Poisson_DistPoisson_Dist
  • PowerPower
  • PpmtPpmt
  • PricePrice
  • PriceDiscPriceDisc
  • PriceMatPriceMat
  • ProbProb
  • ProductProduct
  • ProperProper
  • PvPv
  • QuartileQuartile
  • Quartile_ExcQuartile_Exc
  • Quartile_IncQuartile_Inc
  • QuotientQuotient
  • RadiansRadians
  • RandBetweenRandBetween
  • RankRank
  • Rank_AvgRank_Avg
  • Rank_EqRank_Eq
  • RateRate
  • ReceivedReceived
  • ReplaceReplace
  • ReplaceBReplaceB
  • ReptRept
  • RomanRoman
  • RoundRound
  • RoundDownRoundDown
  • RoundUpRoundUp
  • RSqRSq
  • RTDRTD
  • SearchSearch
  • SearchBSearchB
  • SeriesSumSeriesSum
  • SinhSinh
  • SkewSkew
  • SlnSln
  • SlopeSlope
  • SmallSmall
  • SqrtPiSqrtPi
  • StandardizeStandardize
  • StDevStDev
  • StDev_PStDev_P
  • StDev_SStDev_S
  • StDevPStDevP
  • StEyxStEyx
  • SubstituteSubstitute
  • SubtotalSubtotal
  • SumSum
  • SumIfSumIf
  • SumIfsSumIfs
  • SumProductSumProduct
  • SumSqSumSq
  • SumX2MY2SumX2MY2
  • SumX2PY2SumX2PY2
  • SumXMY2SumXMY2
  • SydSyd
  • T_DistT_Dist
  • T_Dist_2tT_Dist_2t
  • T_Dist_RTT_Dist_RT
  • T_InvT_Inv
  • T_Inv_2TT_Inv_2T
  • T_TestT_Test
  • TanhTanh
  • TBillEqTBillEq
  • TBillPriceTBillPrice
  • TBillYieldTBillYield
  • TDistTDist
  • TextText
  • TInvTInv
  • TransposeTranspose
  • TrendTrend
  • TrimTrim
  • TrimMeanTrimMean
  • TTestTTest
  • USDollarUSDollar
  • VarVar
  • Var_PVar_P
  • Var_SVar_S
  • VarPVarP
  • VdbVdb
  • VLookupVLookup
  • WeekdayWeekday
  • WeekNumWeekNum
  • WeibullWeibull
  • Weibull_DistWeibull_Dist
  • WorkDayWorkDay
  • WorkDay_IntlWorkDay_Intl
  • XirrXirr
  • XnpvXnpv
  • YearFracYearFrac
  • YieldDiscYieldDisc
  • YieldMatYieldMat
  • Z_TestZ_Test
  • ZTestZTest

サポートとフィードバックSupport and feedback

Office VBA またはこの説明書に関するご質問やフィードバックがありますか?Have questions or feedback about Office VBA or this documentation? サポートの受け方およびフィードバックをお寄せいただく方法のガイダンスについては、Office VBA のサポートおよびフィードバックを参照してください。Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.