Connect with us

MS Excel

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

Published

on

How to use Excel function FALSE and EXP correctly - Very easy

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.

How to use Excel function FALSE and EXP correctly - Very easy

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.

Advertisement

MS Excel

How to Give Password in Excel Document

Published

on

How to Give Password in Excel Document

Giving a password to an Excel document is really something you need to do, especially if the document you have is an important document.

After you protect or provide a password, only people who know the password will be able to open the document.

But how to give the password? It’s so easy. Here’s the full tutorial.

TUTORIAL ON GIVING EXCEL PASSWORD

Once you are done with all your data, do a Save As as usual.

How to Give Password in Excel Document

But, before you click Save, select Tools – General Options like this.

If you notice, on the pop-up menu there is a Read-only recommended option.

And if you check or tick the option, it means that anyone who opens your document will get a notification that they can only view it without being able to edit it.

This option is sometimes exercised by some users who want to share documents without others being able to edit them.

After you press Ok, re-enter the password several times and finally save.

How to Give Password in Excel Document

When you have done all the steps when you want to open the document you are required to enter a password.

Remove Excel Password

Then how to remove the password? Although easy, unfortunately, you have to be able to open the document first.

If you have, then repeat the same steps until the stage of entering the password, but it has been filled like this.

How to Give Password in Excel Document

You just need to delete the password and press Ok. The password has been lost and you can open the document without having to enter a password.

That’s all and good luck.

Continue Reading

MS Excel

How to Generate Random Numbers in Microsoft Excel

Published

on

How to Generate Random Numbers in Microsoft Excel

How to make random numbers or random will be easiest when you use Microsoft Excel.

Make no mistake, there are some things that will require random numbers, for example, random sampling, lottery quizzes, and much more.

Even if you use a formula, it’s really easy. How? Here’s the full tutorial.

HOW TO GENERATE RANDOM NUMBERS

There are several formulas that you can use, and of course, it depends on your needs.

The first and easiest is to use the formula =RAND(), you immediately write the formula without any other additions.

However, the formula will only return numbers greater than 0 less than 1 and no specific parameters.

Examples like this.

Numbers With Certain Parameters

In addition to this method, you can use other methods and generate numbers with certain parameters. And this is the most frequently used.

The formula is = RANDBETWEEN(Least Number;Highest Number)

By using this formula, you can determine what is the smallest value and the largest value.

How to Generate Random Numbers in Microsoft Excel

In this example, I chose the smallest number to be 10, while the largest number was 20. The results were in line with what I expected, which is a range of numbers from 10 to 20.

Well, those are two ways that you can use to generate random numbers.

Each method has its own function.

That’s it for this tutorial and good luck!

Continue Reading

MS Excel

How to Randomize Names in Microsoft Excel

Published

on

How to Randomize Names in Microsoft Excel

If We have previously discussed how to generate random numbers, this time we will share how to randomize names in Microsoft Excel.

Don’t get me wrong, these two things are different, you guys. And the method is definitely different too.

It looks simple but sometimes it is necessary. How to? Come on, see.

HOW TO RANDOMIZE NAMES IN EXCEL

Even though they are different, basically they still have a relationship with generating random numbers that we previously discussed, because they still involve the RANDBETWEEN formula. But not completely the same.

This time we will try to randomize a name with an example like this.

How to Randomize Names in Microsoft Excel

Next we will use a formula =INDEX($A$1: $A$14;RANDBETWEEN(1;14))

The explanation of the formula is that RANDBETWEEN will generate a random number between 1 to 14, and the result will be used by INDEX to determine which data will be generated.

And, after you write the formula the result will be like this.

How to Randomize Names in Microsoft Excel

Of the four results of the name, using the same formula. So, the names are really random.

In fact, after a while and you use the same formula the results will also be different, really.

For those of you who still don’t understand the use of RANDBETWEEN, you can read the previous article with the title making random numbers, yes.

Continue Reading
Advertisement

Latest

How to find a TikTok user - Sync friends from social networks How to find a TikTok user - Sync friends from social networks
TikTok6 hours ago

How to find a TikTok user – Sync friends from social networks

SHARE How to find a TikTok user:- Since its launch, TikTok has gained a lot of popularity among various groups...

How to Lock a Document in Microsoft Word How to Lock a Document in Microsoft Word
MS Word1 day ago

How to Lock a Document in Microsoft Word

SHARE In this lesson, we will learn how to lock a document in Microsoft Word with a password. Well, for...

How to Edit PDF to Word Using Microsoft Word How to Edit PDF to Word Using Microsoft Word
MS Word1 day ago

How to Edit PDF to Word Using Microsoft Word

SHARE The easiest way to edit PDF files is with Microsoft Word, usually, this is needed to tidy up the...

How to Give Password in Excel Document How to Give Password in Excel Document
MS Excel1 day ago

How to Give Password in Excel Document

SHARE Giving a password to an Excel document is really something you need to do, especially if the document you...

How to Generate Random Numbers in Microsoft Excel How to Generate Random Numbers in Microsoft Excel
MS Excel1 day ago

How to Generate Random Numbers in Microsoft Excel

SHARE How to make random numbers or random will be easiest when you use Microsoft Excel. Make no mistake, there...

How to Save a Small Document in Microsoft Word How to Save a Small Document in Microsoft Word
MS Word2 days ago

How to Save a Small Document in Microsoft Word

SHARE Discusses how to save small documents in Microsoft Word, which some people may need. This is possible for Microsoft...

How to Print Documents of Certain Pages in Microsoft Word How to Print Documents of Certain Pages in Microsoft Word
MS Word2 days ago

How to Print Documents of Certain Pages in Microsoft Word

SHARE This time we will discuss how to print certain page documents in Microsoft Word. Printing one page may already...

How to Randomize Names in Microsoft Excel How to Randomize Names in Microsoft Excel
MS Excel2 days ago

How to Randomize Names in Microsoft Excel

SHARE If We have previously discussed how to generate random numbers, this time we will share how to randomize names...

How to Cross Out Specific Data in Microsoft Excel How to Cross Out Specific Data in Microsoft Excel
MS Excel2 days ago

How to Cross Out Specific Data in Microsoft Excel

SHARE Microsoft Excel also provides a feature that allows you to cross out or give a line based on certain...

How to Quickly Change Case in Microsoft Word How to Quickly Change Case in Microsoft Word
MS Word3 days ago

How to Quickly Change Case in Microsoft Word

SHARE You can quickly change the case of letters in Microsoft Word with the following keyboard combinations or shortcuts, let’s...

Advertisement

Categories

Trending

Copy link
Powered by Social Snap