# What is the syntax to use the DURATION.MODIF function in Excel? Published

on If you are learning or starting in the stock market it is necessary that you know some advantages of Excel that will surely be of great help; In this way, you can get the results of the calculations correctly and easily, such as using the DURATION.MODIF function.

In this sense, the DURATION.MODIF function in Excel is basically responsible for returning the annual duration; or also called Macauley, of a stock market value, which will be composed of a series of data or syntax to be able to get the information you are looking for.

When we refer to the syntax to use an Excel function, it indicates the order or arrangement and arguments; that is, they are data that we must enter correctly so that we can find the value, since otherwise, it will give an error, in this case, if you wish you can as a complement consult the Microsoft support help.

## What is the correct syntax for the DURATION.MODIF function?

In this case, it is necessary to use the correct syntax in this way, the DURATION.MODIF function will be able to return the nominal value; then the arguments and correct order should be (settlement, expiration, coupon, yield, frequency [base]).

Likewise, to use formulas in spreadsheets it is necessary to have basic knowledge. In this way you will be able to load each of the data and thus use the correct and complete syntax as follows; DURATION.MODIF (settlement, maturity, coupon, yield, frequency [base]).

### Settlement

Basically, we refer to the settlement date of the market value; In other words, it is the date after its issuance on which the buyer acquires the cost of the share of the economic title.

### Expiration

In this case, it represents the expiration date of the stock; or also the exact time in which it will expire, either the economic title or share acquired by the buyer.

### Coupon

The coupon is made up of numerical data that will be greater than or equal to 0; on the other hand, it will indicate what is the annual nominal interest rate of the stock market value; however, if a negative number is entered the function returns #NUM! Or if it is not numeric, it will show #VALUE! Error.

### Performance

Regarding performance, in principle it should only be numerical data, also greater than or equal to 0; it also shows the annual profit rate of the stock market value. In case of being a negative number, it will show the code #NUM !, and if it does not have numbers, then it will give #VALUE! Error.

### Frequency

It will always be necessary to know the importance of using spreadsheets since with them we can get the calculations quickly; as in this case where the frequency represents how many payments are made per year.

For example, if it is 1 it determines that it is once a year, that is, the payment is made annually; but if it is 2 then we speak semester or every 6 months and finally 4 which means quarterly, equally if the frequency is not calculated in 1, 2 or 4 it will give an error or if it is not numerical it will happen in the same way.

### Base

The base will include an integer numerical value that this time will be greater than or equal to 0 and also less than or equal to 4; on the other hand, it will only indicate how the days will be counted and thus calculate the result.

## What should you know about the DURATION.MODIF function?

Not everything in Excel is so complex, you can easily use other functions to calculate the average or any other data you need, but in the specific issue of DURATION.MODIF there are values ​​that you must take into account since otherwise, the information will not be correct.

All values ​​will be mandatory, settlement, maturity, coupon, yield, and frequency, less the basis; In this sense, it will not be necessary to calculate it, you only have to locate 0 and enter the numbers 1, 2, 3, or 4 taking into account the calculation according to the days established by each system.

# 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.