Excel

TBILLEQ: Excel Formulae Explained

How do you use TBILLEQ in Excel?

The TBILLEQ function in Excel is used to calculate the bond equivalent yield (BY) of a bond. The BY is the annual yield on a bond if it were to be held to maturity and its coupons were reinvested at the same rate. The TBILLEQ function takes the following arguments:

-Bond price (P)

-Coupon rate (R)

-Years to maturity (N)

-Basis (B)

The function returns the BY for the bond. The basis can be either "Actual/365" or "Actual/360". The "Actual/365" basis is used for bonds that have a maturity date in the current year. The "Actual/360" basis is used for bonds that have a maturity date in a future year.

What is the syntax of TBILLEQ in Excel?

The syntax of TBILLEQ in Excel is as follows:

=TBILLEQ(database,field,criteria)

database is the range of cells that contains the data to be queried.

field is the column in the database that contains the data to be queried.

criteria is the criteria that is to be used to filter the data.

What is an example of how to use TBILLEQ in Excel?

Assuming you have the data in cells A1:A10, the following formula in cell B1 would return "True" if the values in A1 and A2 are equal, "False" if they are not equal, and "NA" if one or both cells are blank:

=TBILLEQ(A1,A2)

When should you not use TBILLEQ in Excel?

There are a few occasions when you should not use TBILLEQ in Excel. First, if you have data that is not sorted in ascending order, TBILLEQ will not work. Second, if you have text values in your data set, TBILLEQ will not work. Finally, if you have data that is not in a list format, TBILLEQ will not work.

What are some similar formulae to TBILLEQ in Excel?

There are a few similar formulae to TBILLEQ in Excel. The first is TBILLEQ2, which is very similar to TBILLEQ. The only difference is that TBILLEQ2 uses the VLOOKUP function to look up values in a table, while TBILLEQ uses the INDEX and MATCH functions. Another similar formula is HLOOKUP. HLOOKUP looks up values in a table using the horizontal axis, while VLOOKUP looks up values in a table using the vertical axis. Finally, the COUNTIF function can be used to count the number of cells that match a certain criteria. For example, the formula COUNTIF(A:A, ">5") would count the number of cells in the range A:A that are greater than 5.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.