Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Office and SharePoint development
Office client development
Office 2013
Excel 2013
Welcome to the Excel 2013 developer reference
Object model reference (Excel 2013 developer reference)
WorksheetFunction Object (Excel)
WorksheetFunction Methods (Excel)
WorksheetFunction.AccrInt Method (Excel)
WorksheetFunction.AccrIntM Method (Excel)
WorksheetFunction.Acos Method (Excel)
WorksheetFunction.Acosh Method (Excel)
WorksheetFunction.Acot Method (Excel)
WorksheetFunction.Acoth Method (Excel)
WorksheetFunction.Aggregate Method (Excel)
WorksheetFunction.AmorDegrc Method (Excel)
WorksheetFunction.AmorLinc Method (Excel)
WorksheetFunction.And Method (Excel)
WorksheetFunction.Arabic Method (Excel)
WorksheetFunction.Asc Method (Excel)
WorksheetFunction.Asin Method (Excel)
WorksheetFunction.Asinh Method (Excel)
WorksheetFunction.Atan2 Method (Excel)
WorksheetFunction.Atanh Method (Excel)
WorksheetFunction.AveDev Method (Excel)
WorksheetFunction.Average Method (Excel)
WorksheetFunction.AverageIf Method (Excel)
WorksheetFunction.AverageIfs Method (Excel)
WorksheetFunction.BahtText Method (Excel)
WorksheetFunction.Base Method (Excel)
WorksheetFunction.BesselI Method (Excel)
WorksheetFunction.BesselJ Method (Excel)
WorksheetFunction.BesselK Method (Excel)
WorksheetFunction.BesselY Method (Excel)
WorksheetFunction.Beta_Dist Method (Excel)
WorksheetFunction.Beta_Inv Method (Excel)
WorksheetFunction.BetaDist Method (Excel)
WorksheetFunction.BetaInv Method (Excel)
WorksheetFunction.Bin2Dec Method (Excel)
WorksheetFunction.Bin2Hex Method (Excel)
WorksheetFunction.Bin2Oct Method (Excel)
WorksheetFunction.Binom_Dist Method (Excel)
WorksheetFunction.Binom_Dist_Range Method (Excel)
WorksheetFunction.Binom_Inv Method (Excel)
WorksheetFunction.BinomDist Method (Excel)
WorksheetFunction.Bitand Method (Excel)
WorksheetFunction.Bitlshift Method (Excel)
WorksheetFunction.Bitor Method (Excel)
WorksheetFunction.Bitrshift Method (Excel)
WorksheetFunction.Bitxor Method (Excel)
WorksheetFunction.Ceiling Method (Excel)
WorksheetFunction.Ceiling_Math Method (Excel)
WorksheetFunction.Ceiling_Precise Method (Excel)
WorksheetFunction.ChiDist Method (Excel)
WorksheetFunction.ChiInv Method (Excel)
WorksheetFunction.ChiSq_Dist Method (Excel)
WorksheetFunction.ChiSq_Dist_RT Method (Excel)
WorksheetFunction.ChiSq_Inv Method (Excel)
WorksheetFunction.ChiSq_Inv_RT Method (Excel)
WorksheetFunction.ChiSq_Test Method (Excel)
WorksheetFunction.ChiTest Method (Excel)
WorksheetFunction.Choose Method (Excel)
WorksheetFunction.Clean Method (Excel)
WorksheetFunction.Combin Method (Excel)
WorksheetFunction.Combina Method (Excel)
WorksheetFunction.Complex Method (Excel)
WorksheetFunction.Confidence Method (Excel)
WorksheetFunction.Confidence_Norm Method (Excel)
WorksheetFunction.Confidence_T Method (Excel)
WorksheetFunction.Convert Method (Excel)
WorksheetFunction.Correl Method (Excel)
WorksheetFunction.Cosh Method (Excel)
WorksheetFunction.Cot Method (Excel)
WorksheetFunction.Coth Method (Excel)
WorksheetFunction.Count Method (Excel)
WorksheetFunction.CountA Method (Excel)
WorksheetFunction.CountBlank Method (Excel)
WorksheetFunction.CountIf Method (Excel)
WorksheetFunction.CountIfs Method (Excel)
WorksheetFunction.CoupDayBs Method (Excel)
WorksheetFunction.CoupDays Method (Excel)
WorksheetFunction.CoupDaysNc Method (Excel)
WorksheetFunction.CoupNcd Method (Excel)
WorksheetFunction.CoupNum Method (Excel)
WorksheetFunction.CoupPcd Method (Excel)
WorksheetFunction.Covar Method (Excel)
WorksheetFunction.Covariance_P Method (Excel)
WorksheetFunction.Covariance_S Method (Excel)
WorksheetFunction.CritBinom Method (Excel)
WorksheetFunction.Csc Method (Excel)
WorksheetFunction.Csch Method (Excel)
WorksheetFunction.CumIPmt Method (Excel)
WorksheetFunction.CumPrinc Method (Excel)
WorksheetFunction.DAverage Method (Excel)
WorksheetFunction.Days Method (Excel)
WorksheetFunction.Days360 Method (Excel)
WorksheetFunction.Db Method (Excel)
WorksheetFunction.Dbcs Method (Excel)
WorksheetFunction.DCount Method (Excel)
WorksheetFunction.DCountA Method (Excel)
WorksheetFunction.Ddb Method (Excel)
WorksheetFunction.Dec2Bin Method (Excel)
WorksheetFunction.Dec2Hex Method (Excel)
WorksheetFunction.Dec2Oct Method (Excel)
WorksheetFunction.Decimal Method (Excel)
WorksheetFunction.Degrees Method (Excel)
WorksheetFunction.Delta Method (Excel)
WorksheetFunction.DevSq Method (Excel)
WorksheetFunction.DGet Method (Excel)
WorksheetFunction.Disc Method (Excel)
WorksheetFunction.DMax Method (Excel)
WorksheetFunction.DMin Method (Excel)
WorksheetFunction.Dollar Method (Excel)
WorksheetFunction.DollarDe Method (Excel)
WorksheetFunction.DollarFr Method (Excel)
WorksheetFunction.DProduct Method (Excel)
WorksheetFunction.DStDev Method (Excel)
WorksheetFunction.DStDevP Method (Excel)
WorksheetFunction.DSum Method (Excel)
WorksheetFunction.Duration Method (Excel)
WorksheetFunction.DVar Method (Excel)
WorksheetFunction.DVarP Method (Excel)
WorksheetFunction.EDate Method (Excel)
WorksheetFunction.Effect Method (Excel)
WorksheetFunction.EncodeUrl Method (Excel)
WorksheetFunction.EoMonth Method (Excel)
WorksheetFunction.Erf Method (Excel)
WorksheetFunction.Erf_Precise Method (Excel)
WorksheetFunction.ErfC Method (Excel)
WorksheetFunction.ErfC_Precise Method (Excel)
WorksheetFunction.Even Method (Excel)
WorksheetFunction.Expon_Dist Method (Excel)
WorksheetFunction.ExponDist Method (Excel)
WorksheetFunction.F_Dist Method (Excel)
WorksheetFunction.F_Dist_RT Method (Excel)
WorksheetFunction.F_Inv Method (Excel)
WorksheetFunction.F_Inv_RT Method (Excel)
WorksheetFunction.F_Test Method (Excel)
WorksheetFunction.Fact Method (Excel)
WorksheetFunction.FactDouble Method (Excel)
WorksheetFunction.FDist Method (Excel)
WorksheetFunction.FilterXML Method (Excel)
WorksheetFunction.Find Method (Excel)
WorksheetFunction.FindB Method (Excel)
WorksheetFunction.FInv Method (Excel)
WorksheetFunction.Fisher Method (Excel)
WorksheetFunction.FisherInv Method (Excel)
WorksheetFunction.Fixed Method (Excel)
WorksheetFunction.Floor Method (Excel)
WorksheetFunction.Floor_Math Method (Excel)
WorksheetFunction.Floor_Precise Method (Excel)
WorksheetFunction.Forecast Method (Excel)
WorksheetFunction.Frequency Method (Excel)
WorksheetFunction.FTest Method (Excel)
WorksheetFunction.Fv Method (Excel)
WorksheetFunction.FVSchedule Method (Excel)
WorksheetFunction.Gamma Method (Excel)
WorksheetFunction.Gamma_Dist Method (Excel)
WorksheetFunction.Gamma_Inv Method (Excel)
WorksheetFunction.GammaDist Method (Excel)
WorksheetFunction.GammaInv Method (Excel)
WorksheetFunction.GammaLn Method (Excel)
WorksheetFunction.GammaLn_Precise Method (Excel)
WorksheetFunction.Gauss Method (Excel)
WorksheetFunction.Gcd Method (Excel)
WorksheetFunction.GeoMean Method (Excel)
WorksheetFunction.GeStep Method (Excel)
WorksheetFunction.Growth Method (Excel)
WorksheetFunction.HarMean Method (Excel)
WorksheetFunction.Hex2Bin Method (Excel)
WorksheetFunction.Hex2Dec Method (Excel)
WorksheetFunction.Hex2Oct Method (Excel)
WorksheetFunction.HLookup Method (Excel)
WorksheetFunction.HypGeom_Dist Method (Excel)
WorksheetFunction.HypGeomDist Method (Excel)
WorksheetFunction.IfError Method (Excel)
WorksheetFunction.IfNa Method (Excel)
WorksheetFunction.ImAbs Method (Excel)
WorksheetFunction.Imaginary Method (Excel)
WorksheetFunction.ImArgument Method (Excel)
WorksheetFunction.ImConjugate Method (Excel)
WorksheetFunction.ImCos Method (Excel)
WorksheetFunction.ImCosh Method (Excel)
WorksheetFunction.ImCot Method (Excel)
WorksheetFunction.ImCsc Method (Excel)
WorksheetFunction.ImCsch Method (Excel)
WorksheetFunction.ImDiv Method (Excel)
WorksheetFunction.ImExp Method (Excel)
WorksheetFunction.ImLn Method (Excel)
WorksheetFunction.ImLog10 Method (Excel)
WorksheetFunction.ImLog2 Method (Excel)
WorksheetFunction.ImPower Method (Excel)
WorksheetFunction.ImProduct Method (Excel)
WorksheetFunction.ImReal Method (Excel)
WorksheetFunction.ImSec Method (Excel)
WorksheetFunction.ImSech Method (Excel)
WorksheetFunction.ImSin Method (Excel)
WorksheetFunction.ImSinh Method (Excel)
WorksheetFunction.ImSqrt Method (Excel)
WorksheetFunction.ImSub Method (Excel)
WorksheetFunction.ImSum Method (Excel)
WorksheetFunction.ImTan Method (Excel)
WorksheetFunction.Index Method (Excel)
WorksheetFunction.Intercept Method (Excel)
WorksheetFunction.IntRate Method (Excel)
WorksheetFunction.Ipmt Method (Excel)
WorksheetFunction.Irr Method (Excel)
WorksheetFunction.IsErr Method (Excel)
WorksheetFunction.IsError Method (Excel)
WorksheetFunction.IsEven Method (Excel)
WorksheetFunction.IsFormula Method (Excel)
WorksheetFunction.IsLogical Method (Excel)
WorksheetFunction.IsNA Method (Excel)
WorksheetFunction.IsNonText Method (Excel)
WorksheetFunction.IsNumber Method (Excel)
WorksheetFunction.ISO_Ceiling Method (Excel)
WorksheetFunction.IsOdd Method (Excel)
WorksheetFunction.IsoWeekNum Method (Excel)
WorksheetFunction.Ispmt Method (Excel)
WorksheetFunction.IsText Method (Excel)
WorksheetFunction.Kurt Method (Excel)
WorksheetFunction.Large Method (Excel)
WorksheetFunction.Lcm Method (Excel)
WorksheetFunction.LinEst Method (Excel)
WorksheetFunction.Ln Method (Excel)
WorksheetFunction.Log Method (Excel)
WorksheetFunction.Log10 Method (Excel)
WorksheetFunction.LogEst Method (Excel)
WorksheetFunction.LogInv Method (Excel)
WorksheetFunction.LogNorm_Dist Method (Excel)
WorksheetFunction.LogNorm_Inv Method (Excel)
WorksheetFunction.LogNormDist Method (Excel)
WorksheetFunction.Lookup Method (Excel)
WorksheetFunction.Match Method (Excel)
WorksheetFunction.Max Method (Excel)
WorksheetFunction.MDeterm Method (Excel)
WorksheetFunction.MDuration Method (Excel)
WorksheetFunction.Median Method (Excel)
WorksheetFunction.Min Method (Excel)
WorksheetFunction.MInverse Method (Excel)
WorksheetFunction.MIrr Method (Excel)
WorksheetFunction.MMult Method (Excel)
WorksheetFunction.Mode Method (Excel)
WorksheetFunction.Mode_Mult Method (Excel)
WorksheetFunction.Mode_Sngl Method (Excel)
WorksheetFunction.MRound Method (Excel)
WorksheetFunction.MultiNomial Method (Excel)
WorksheetFunction.Munit Method (Excel)
WorksheetFunction.NegBinom_Dist Method (Excel)
WorksheetFunction.NegBinomDist Method (Excel)
WorksheetFunction.NetworkDays Method (Excel)
WorksheetFunction.NetworkDays_Intl Method (Excel)
WorksheetFunction.Nominal Method (Excel)
WorksheetFunction.Norm_Dist Method (Excel)
WorksheetFunction.Norm_Inv Method (Excel)
WorksheetFunction.Norm_S_Dist Method (Excel)
WorksheetFunction.Norm_S_Inv Method (Excel)
WorksheetFunction.NormDist Method (Excel)
WorksheetFunction.NormInv Method (Excel)
WorksheetFunction.NormSDist Method (Excel)
WorksheetFunction.NormSInv Method (Excel)
WorksheetFunction.NPer Method (Excel)
WorksheetFunction.Npv Method (Excel)
WorksheetFunction.NumberValue Method (Excel)
WorksheetFunction.Oct2Bin Method (Excel)
WorksheetFunction.Oct2Dec Method (Excel)
WorksheetFunction.Oct2Hex Method (Excel)
WorksheetFunction.Odd Method (Excel)
WorksheetFunction.OddFPrice Method (Excel)
WorksheetFunction.OddFYield Method (Excel)
WorksheetFunction.OddLPrice Method (Excel)
WorksheetFunction.OddLYield Method (Excel)
WorksheetFunction.Or Method (Excel)
WorksheetFunction.PDuration Method (Excel)
WorksheetFunction.Pearson Method (Excel)
WorksheetFunction.Percentile Method (Excel)
WorksheetFunction.Percentile_Exc Method (Excel)
WorksheetFunction.Percentile_Inc Method (Excel)
WorksheetFunction.PercentRank Method (Excel)
WorksheetFunction.PercentRank_Exc Method (Excel)
WorksheetFunction.PercentRank_Inc Method (Excel)
WorksheetFunction.Permut Method (Excel)
WorksheetFunction.Permutationa Method (Excel)
WorksheetFunction.Phi Method (Excel)
WorksheetFunction.Phonetic Method (Excel)
WorksheetFunction.Pi Method (Excel)
WorksheetFunction.Pmt Method (Excel)
WorksheetFunction.Poisson Method (Excel)
WorksheetFunction.Poisson_Dist Method (Excel)
WorksheetFunction.Power Method (Excel)
WorksheetFunction.Ppmt Method (Excel)
WorksheetFunction.Price Method (Excel)
WorksheetFunction.PriceDisc Method (Excel)
WorksheetFunction.PriceMat Method (Excel)
WorksheetFunction.Prob Method (Excel)
WorksheetFunction.Product Method (Excel)
WorksheetFunction.Proper Method (Excel)
WorksheetFunction.Pv Method (Excel)
WorksheetFunction.Quartile Method (Excel)
WorksheetFunction.Quartile_Exc Method (Excel)
WorksheetFunction.Quartile_Inc Method (Excel)
WorksheetFunction.Quotient Method (Excel)
WorksheetFunction.Radians Method (Excel)
WorksheetFunction.RandBetween Method (Excel)
WorksheetFunction.Rank Method (Excel)
WorksheetFunction.Rank_Avg Method (Excel)
WorksheetFunction.Rank_Eq Method (Excel)
WorksheetFunction.Rate Method (Excel)
WorksheetFunction.Received Method (Excel)
WorksheetFunction.Replace Method (Excel)
WorksheetFunction.ReplaceB Method (Excel)
WorksheetFunction.Rept Method (Excel)
WorksheetFunction.Roman Method (Excel)
WorksheetFunction.Round Method (Excel)
WorksheetFunction.RoundDown Method (Excel)
WorksheetFunction.RoundUp Method (Excel)
WorksheetFunction.Rri Method (Excel)
WorksheetFunction.RSq Method (Excel)
WorksheetFunction.RTD Method (Excel)
WorksheetFunction.Search Method (Excel)
WorksheetFunction.SearchB Method (Excel)
WorksheetFunction.Sec Method (Excel)
WorksheetFunction.Sech Method (Excel)
WorksheetFunction.SeriesSum Method (Excel)
WorksheetFunction.Sinh Method (Excel)
WorksheetFunction.Skew Method (Excel)
WorksheetFunction.Skew_p Method (Excel)
WorksheetFunction.Sln Method (Excel)
WorksheetFunction.Slope Method (Excel)
WorksheetFunction.Small Method (Excel)
WorksheetFunction.SqrtPi Method (Excel)
WorksheetFunction.Standardize Method (Excel)
WorksheetFunction.StDev Method (Excel)
WorksheetFunction.StDev_P Method (Excel)
WorksheetFunction.StDev_S Method (Excel)
WorksheetFunction.StDevP Method (Excel)
WorksheetFunction.StEyx Method (Excel)
WorksheetFunction.Substitute Method (Excel)
WorksheetFunction.Subtotal Method (Excel)
WorksheetFunction.Sum Method (Excel)
WorksheetFunction.SumIf Method (Excel)
WorksheetFunction.SumIfs Method (Excel)
WorksheetFunction.SumProduct Method (Excel)
WorksheetFunction.SumSq Method (Excel)
WorksheetFunction.SumX2MY2 Method (Excel)
WorksheetFunction.SumX2PY2 Method (Excel)
WorksheetFunction.SumXMY2 Method (Excel)
WorksheetFunction.Syd Method (Excel)
WorksheetFunction.T_Dist Method (Excel)
WorksheetFunction.T_Dist_2T Method (Excel)
WorksheetFunction.T_Dist_RT Method (Excel)
WorksheetFunction.T_Inv Method (Excel)
WorksheetFunction.T_Inv_2T Method (Excel)
WorksheetFunction.T_Test Method (Excel)
WorksheetFunction.Tanh Method (Excel)
WorksheetFunction.TBillEq Method (Excel)
WorksheetFunction.TBillPrice Method (Excel)
WorksheetFunction.TBillYield Method (Excel)
WorksheetFunction.TDist Method (Excel)
WorksheetFunction.Text Method (Excel)
WorksheetFunction.TInv Method (Excel)
WorksheetFunction.Transpose Method (Excel)
WorksheetFunction.Trend Method (Excel)
WorksheetFunction.Trim Method (Excel)
WorksheetFunction.TrimMean Method (Excel)
WorksheetFunction.TTest Method (Excel)
WorksheetFunction.Unichar Method (Excel)
WorksheetFunction.Unicode Method (Excel)
WorksheetFunction.USDollar Method (Excel)
WorksheetFunction.Var Method (Excel)
WorksheetFunction.Var_P Method (Excel)
WorksheetFunction.Var_S Method (Excel)
WorksheetFunction.VarP Method (Excel)
WorksheetFunction.Vdb Method (Excel)
WorksheetFunction.VLookup Method (Excel)
WorksheetFunction.WebService Method (Excel)
WorksheetFunction.Weekday Method (Excel)
WorksheetFunction.WeekNum Method (Excel)
WorksheetFunction.Weibull Method (Excel)
WorksheetFunction.Weibull_Dist Method (Excel)
WorksheetFunction.WorkDay Method (Excel)
WorksheetFunction.WorkDay_Intl Method (Excel)
WorksheetFunction.Xirr Method (Excel)
WorksheetFunction.Xnpv Method (Excel)
WorksheetFunction.Xor Method (Excel)
WorksheetFunction.YearFrac Method (Excel)
WorksheetFunction.YieldDisc Method (Excel)
WorksheetFunction.YieldMat Method (Excel)
WorksheetFunction.Z_Test Method (Excel)
WorksheetFunction.ZTest Method (Excel)
Expand Minimize
This topic has not yet been rated - Rate this topic

WorksheetFunction.ImConjugate Method (Excel)

Office 2013

Published: July 16, 2012

Returns the complex conjugate of a complex number in x + yi or x + yj text format.

expression .ImConjugate(Arg1)

expression A variable that represents a WorksheetFunction object.

Parameters

Name

Required/Optional

Data Type

Description

Arg1

Required

Variant

Inumber - a complex number for which you want the conjugate.

Return Value

String

  • 2Use COMPLEX to convert real and imaginary coefficients into a complex number.

  • The conjugate of a complex number is: Ff198074.awfimcon_ZA06051156(en-us,office.15).gif

Did you find this helpful?
(1500 characters remaining)
© 2013 Microsoft. All rights reserved.
|
Site Feedback
© 2013 Microsoft. All rights reserved.