(C) 2012 - 2018 by Mourad Louha · All rights reserved.

Excel functions

YIELD

Categories: Financial, Functions
Comments: No

Description

The description for the function YIELD is not available yet.

Availability

The YIELD function is available in the following Microsoft Excel versions.

ProductAvailableCategoryNotes
Excel 2013YesFinancial
Excel 2010YesFinancial
Excel 2007YesFinancial
Excel 2003No

Syntax

YIELD(Settlement,Maturity,Rate,Pr,Redemption,Frequency,Basis)

Arguments

The YIELD has the following arguments. Required arguments are bold.

DesignationDescription
Settlement
Maturity
Rate
Pr
Redemption
Frequency
Basis

 


Description

The description for the function YIELDDISC is not available yet.

Availability

The YIELDDISC function is available in the following Microsoft Excel versions.

ProductAvailableCategoryNotes
Excel 2013YesFinancial
Excel 2010YesFinancial
Excel 2007YesFinancial
Excel 2003No

Syntax

YIELDDISC(Settlement,Maturity,Pr,Redemption,Basis)

Arguments

The YIELDDISC has the following arguments. Required arguments are bold.

DesignationDescription
Settlement
Maturity
Pr
Redemption
Basis

 


Description

The description for the function YIELDMAT is not available yet.

Availability

The YIELDMAT function is available in the following Microsoft Excel versions.

ProductAvailableCategoryNotes
Excel 2013YesFinancial
Excel 2010YesFinancial
Excel 2007YesFinancial
Excel 2003No

Syntax

YIELDMAT(Settlement,Maturity,Issue,Rate,Pr,Basis)

Arguments

The YIELDMAT has the following arguments. Required arguments are bold.

DesignationDescription
Settlement
Maturity
Issue
Rate
Pr
Basis

 


Description

The description for the function Z.TEST is not available yet.

Availability

The Z.TEST function is available in the following Microsoft Excel versions.

ProductAvailableCategoryNotes
Excel 2013YesStatistical
Excel 2010YesStatistical
Excel 2007No
Excel 2003No

Syntax

Z.TEST(Array,X,Sigma)

Arguments

The Z.TEST has the following arguments. Required arguments are bold.

DesignationDescription
Array
X
Sigma

 


Description

The description for the function ZTEST is not available yet.

Availability

The ZTEST function is available in the following Microsoft Excel versions.

ProductAvailableCategoryNotes
Excel 2013YesCompatibility
Excel 2010YesCompatibility
Excel 2007YesStatistical
Excel 2003YesStatistical

Syntax

ZTEST(Array,X,Sigma)

Arguments

The ZTEST has the following arguments. Required arguments are bold.

DesignationDescription
Array
X
Sigma

 

 
Top