# How to use Excel function FALSE and EXP correctly – Very easy Published

on Nowadays it is very common to use different functions in different programs to facilitate the calculations that at a certain moment could take place at work, or in any other activity that is developed. Such is the case of Office Excel or iWork, which offers you various features to perform complex and repetitive calculations.

In this post, we will be talking about how to use the Excel function correctly FALSE and EXP in a simple way, in addition, we will talk about the applications that you can give to them, so you can carry out work with these functions.

## What are FALSE and EXP functions for Excel?

Before starting with the syntax and examples of the use of these formulas, you must have previous knowledge of the use of Excel. In this sense, you will see that the FALSE and EXP functions will help you solve various aspects related to logical and mathematical problems. The first one, that is, the FALSE formula will return a logical expression that represents the same word.

This function does not require arguments, and it will be useful to logically fix situations that do not represent reality. For example, you put False to the expression “Frogs have 8 legs”, you know that it is not possible for frogs to have 8 legs, hence it makes sense to put the word false to said expression.

On the other hand, you will have the EXP function that will be very useful to solve expressions based on the constant number 2.71828182845904, which is the base of the natural logarithm.

Well yes, you will see that it is related to the mathematical expressions that are handled in studies at various levels. You can even make use of them to determine the behavior of process control curves in the industry, analyze the value of money over time, and other elements of various natures.

As an alternative to using the EXP formula in Excel, you will have the EXP.NDIST function, which will provide you with more complete tools to perform statistical analysis on a set of data. In general, these formulas will be very helpful for you in handling Excel.

## Using the FALSE and EXP functions in Excel

As previously pointed out, the FALSE function does not require any type of data to function properly, however, you must place it correctly so that it does not throw an Error, because although it does not need an argument, Excel requires that you place the word FALSE (). As you can see, the inside of the parentheses is left empty, where the cell or the data value is usually placed in the formula.

On the other hand, you will have the possibility of complementing your logical expressions with the use of the TRUE function, since, as its name indicates, this expression determines or represents the reality of an expression. In this sense, you will have a complete tool that will allow you to logically determine the state of a real situation.

In the case of the EXP function, you will need to put data inside the parentheses, because unlike the FALSE formula, this function analyzes the data to deliver a number by multiplying the base (2.71828182845904) by itself the number of times indicated in the argument:

• EXP function requires argument and is written EXP (Number)
• Keep in mind that an expected expression is a number because if you type any expression other than a number, you will get an error as a result.

There are many examples of the use of the EXP formula, however, in this post, we address the most common way to perform the calculation, without neglecting the view that you can use it to determine values ​​in curves or behavior graphs of certain natural phenomena, industrial and of various kinds. So you can place for example:

• EXP (1) and you will have as a result the real number 2.71828182845904
• EXP (2) and the result you will get will be 7.38905609
• So you can obtain different values ​​according to your needs, below we show you a graph with an example

Finally, if you require more information about Excel functions, you can visit Microsoft’s support page to obtain the information you need and thus complement your knowledge in the use of Excel functions.

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