# How to use COUPON.NUM function to calculate coupons in Excel Published

on The set of programs that Microsoft Office has offered thanks to the Windows operating system has evolved considerably since its first versions. However, one of the programs that stands out the most thanks to its versatility and usefulness in different fields of work, is undoubtedly Excel.

Excel is one of those programs that at first glance may seem complex, but as you learn from it, you can discover all its cutting-edge functions. All starting from the creation of a simple and simple spreadsheet where a number of mathematical or financial operations can be broken down.

And this is where the COUPON.NUM function comes in to calculate coupons in Excel, one of the relevant financial functions of this program. There will be no better support guide for Excel users than some intuition and the following instructions to master this feature.

## COUPON.NUM function to calculate coupons in Excel

The financial functions are essential tools in the execution of financial calculations of some companies, both small and large. These functions include yield calculations, interest rates, rates of return, asset depreciation, investment evaluation, and payments.

And although the main financial functions being widely used are VF, VA, PAYMENT, RATE, and NPER. Today the usefulness of the CUPON.NUM function will be known a little more thoroughly.

The COUPON.NUM function as a financial function is used to calculate the number of coupons between the purchase date of the security and its expiration date. That is, it returns the number of coupon payments between the settlement date and their respective expiration date, thus rounding up to the next whole coupon.

It is important to take into account that the dates entered within this function must be specified through the DATE function or as a result of other formulas in the spreadsheet. A more understandable example for this point would be to enter DATE (2019; 1; 30) to indicate January 30, 2019.

It should be remembered that an error in functions such as CUPOM.NUM can be generated by problems that arise from having entered text in the dates.

## Relationships of the COUPON.NUM function

The CUPON.NUM function has a series of relationships with certain terms that make up its syntax and allows us to understand it much better according to its arguments:

• The settlement is a mandatory argument and can be understood as the purchase date of the security. Since this is the date after the issuance date in which a buyer has just acquired the market value.
• Expiration is a required argument and can be understood as the expiration date of the security. That is, it is the date on which the stock market value has expired.
• Frequency is a required argument and is understood as the number of coupon payments per year. Since the possible values ​​are: annual payments 1, semi-annual payments 2, quarterly payments 4.
• The base is an optional argument that determines on what kind of base the days should be counted. In other words, it is a calculation method, being a numerical value greater than or equal to 0 but less than 4.

## Application of the CUPON.NUM function

You do not have to follow a series of particular steps to be able to apply the COUPON.NUM function, simply once it has been practiced.

To start, just select the cell where you want to see the result. Click on the insert function fx icon that will be located in the upper toolbar, or you can right-click on the selected cell to choose the option to insert function in the menu.

The next thing is to select the Financial function group in the displayed list that will allow you to click on the COUPON.NUM function . This is how you proceed to enter the corresponding arguments separated by their respective commas, to finish by pressing Enter.

The result should be displayed successfully in the cell that has been selected to see the result from the initial step.

# Determining Lowest and Highest Values ​​in Microsoft Excel Published

on Determining the lowest and highest values ​​requires a special formula or function that you can do with Microsoft Excel.

Determining the highest value can be done easily when there is very little data, but what about when there is a lot of data?

For that you need an Excel formula.

How to? Come on, follow this tutorial in full.

## HOW TO DETERMINE THE LOWEST AND HIGHEST VALUE

To do this, the formula you can use is MAX and MIN.

As the name implies, MAX is to find the highest value, while MIN is to find the lowest value.

Meanwhile, for writing the formula, the highest value is MAX(Number1; [Number2]; …)

Number is the range of numbers for which you want to know the highest value.

## Finding Lowest Value

Now, to find the lowest value you can use the formula MIN(Number1; [Number2]; …).

As usual number is a range of numbers, or the same when you look for the previous highest value.

How, very easy isn’t it? Although it looks complicated, Excel formulas will really make things easier for you.

That’s all and good luck.

# How to Use Automatic Ranking Formulas in Excel Published

on The formula for finding rankings in Excel is also available for those of you who want to rank in a group.

This one formula is a formula that is quite widely used, especially in the field of education.

Well, here’s an Excel formula tutorial to find rankings.

## RANKING FORMULAS IN EXCEL

There are several formulas you can use that basically have the same function for finding rankings.

And the first formula you can use is = RANK(Number;Reference;[order]).

The order in the formula is the number 0 or 1 as a ranking reference.

When you want to sort the value in descending or descending order, fill it with 0 or empty, while when you want to give the value ascending then fill it with the number 1.

But you also need to know that the formula will also give the same rank when there are the same values.

To overcome this you can use this one formula.

## RANK.AVG Rumus formula

The usage is still the same, only the formula is different which becomes RANK.AVG(Number; Reference; [order])

And when you apply it and there is the same value, it will produce an average ranking of that value.

So, for an assessment, this formula is the most appropriate.

Well, if you look at the example, a value of 70 gets a rating of 7.5 while a value of 75 gets a rating of 5.5.

That’s how the ranking formula in Excel works.

That’s all and good luck.

# How to Calculate Workdays with Excel Formulas Published

on Calculating weekdays will be very effective when you use the easiest formula in Microsoft Excel.

Most people are lazy to use Excel for their daily needs, even though this software is very useful.

Then what about the formula for finding the working day? It’s really easy. Here’s the full tutorial.

## HOW TO CALCULATE WORKING DAYS

You can do this with the NETWORKDAYS formula which only counts weekdays, without weekends.

But you also need to know that the weekends here are Saturday and Sunday.

For example, if you want to determine the weekend with another day, then there is a different formula which I will discuss later.

The formula for writing is =NETWORKDAYS(Start_Date; End_Date, [Holiday_Day])

For more details, consider the following image.

In this example, the number of effective working days is 87 days, where Saturday and Sunday are not included.

## NETWORKDAYS.ITL

Well, for this formula you can determine the time off or weekend as needed.

The formula for writing is =NETWORKDAYS.INTL(Start_Date; End_Date; [Weekend_End]; [Holiday_Holiday])

The difference in this formula is that [weekends] are used to exclude and treat as weekdays.

If you do not fill it in, it will be considered as the previous formula.

You can also use a holiday code with a seven-character text string consisting of a combination of the text numbers 1 and 0 to represent Monday-Sunday.

So what happens is the number 1 represents holidays while the number 0 for workdays.

For example, on weekends or holidays Saturday and Sunday, the string code you are using is 0000011.

As for working days only Monday, Tuesday and Thursday or Wednesday, Friday, Saturday and Sunday off, the code used is 0010111.

That’s all and good luck.