Connect with us

News

What is the Excel function ISERROR and ISERR used and used for?

Published

on

What is the Excel function ISERROR and ISERR used and used for

Within Excel there are different functions that are part of the group called ES, which in turn are in charge of checking the value specified by the person and allows correcting if it is true or false, depending on the result it produces. Any of these ES functions can be used to learn more about the input data before performing calculations or other actions.

All these functions are very useful formulas that Excel has, which you can consult the support on the official page that provide enough help for the user, such as ISERROR and ISERR that allow you to know if an error has occurred. That is why it is necessary to know what is the purpose and use of the Excel function ISERROR and ISERR?

The ISERROR function allows you to check if the value is an error and it can return said value to TRUE or FALSE, that is, it will evaluate the value placed in a cell or formula. You can also use this formula informs that you make in Excel.

What is the Excel function ISERROR and ISERR used and used for

Whereas the ISERR function is very similar to the one mentioned above, but it only returns TRUE when the evaluated argument is as # N / A. Both functions are formulas that can be used to find out whether or not the data obtained from other sources can throw an error. They can learn to use Excel online easily.

Use of Excel function ISERROR and ISERR

When developing a spreadsheet it is very important to know if an error occurred or not, that is why the use of the Excel function ISERROR and ISERR is of great relevance because with both you can evaluate that and continue working with ease, it is a matter of know the formulas to use and the use of the code function to complement other functions.

Likewise, it must be taken into account that ISERROR corresponds to any of the error values ​​such as: # N / A, # VALUE !, # REF !, # DIV / 0 !, # NUM !, # NAME ? O # NULL !; while in ISERR it can be an error value in Excel making an exception of # N / A, that is, both functions check all possible errors that Excel may have registered.

Excel ISERROR

The ISERROR function in Excel is one that evaluates the value written in a cell and then indicates whether or not it has an error. It should be noted, after the function performs its verification, it will return the value to TRUE, but in case there is no error, the function will return it to FALSE. This function has two parts.

In the first part, place the formula you want to use, in this case, it is = ISERROR, and add the cell you want to verify. In the second part, you write what you want to do next in case the cell verification fails. The syntax is like this: = ISERROR (value or reference). The value that is written is the one you want to check.

The Excel ISERR function

The Excel ISERR function allows you to know if the value of a cell or the result obtained is an error, it also allows you to compare a value against other types of error in the Excel spreadsheet except the # N / A error since will return it with a FALSE value.

What is the Excel function ISERROR and ISERR used and used for

In the case of ISERR, to evaluate the value that was entered in the selected cell, you must click the insert function icon; which is located on the top toolbar, or you can also click the right mouse button on the selected cell, and choose the option insert function in the menu.

Then it goes on to select the function group INFORMATION in the list, where you must click to choose the ISERR function, there you enter the evidence you want and hit the Enter button. The result will automatically be displayed in the selected cell.

Advertisement

News

Electronic Waste is Predicted to Reach 57.4 Million Metric Tons in 202

Published

on

Electronic Waste is Predicted to Reach 57.4 Million Metric Tons in 202

The increasing number of electronic goods produced, it also makes the amount of electronic waste produced also increases every year.

Recently, the WEEE Forum has released a report which states that there is an increase in global e-waste production by 2 metric tons or 3-4 per cent every year.

In 2021, it is predicted that the total electronic waste generated could reach 57.4 million metric tons, which of course must be addressed immediately.

Pascal Leroy as the General of the WEEE Forum also said that there are several reasons that cause electronic waste to increase, one of which is the lack of awareness of people to return used electronic goods so that they can be recycled again.

“As long as people don’t return used goods, damaged equipment, sell them, or even donate them, we still have to mine new materials, which of course damage the environment,” said Leroy, quoted from Eurekalert.

But now a number of big countries such as Europe are starting to implement policies to reduce electronic waste, one of which is making a standard USB Type-C port for gadgets from various brands.

In addition, eliminating the charger adapter in every iPhone purchase is also a pretty good effort in reducing the excessive electronic waste production.

Continue Reading

News

Microsoft shuts down LinkedIn in China as rules tighten

Published

on

Microsoft shuts down LinkedIn in China as rules tighten

On Thursday (14/10/2021) Microsoft said it would close its career-oriented social network LinkedIn in China after seven years of launch. This is done as Beijing tightens control over technology companies.

Companies based in the United States that will replace LinkedIn in China with the application to apply for jobs without networking features, said senior vice president of engineering Mohak Shroff, reported Reuters.

“We face a much more challenging operating environment and greater requirements in China,” Shroff said in a blog post.

According to The Wall Street Journal, LinkedIn was given time by China’s internet regulator to better oversee content on the site.

The move by China is part of a broad policy by the government to tighten its grip on the economy, including targeting private education, property and casinos.

LinkedIn, which was launched in China in 2014, is not only a place to find work but also a place to exchange business information and news.

Not only LinkedIn, Facebook and Twitter have been banned from China for more than a decade. Meanwhile, Google left China in 2010.

Continue Reading

News

Windows 11 Bug Makes AMD Processors Slow, Microsoft and AMD Find Solutions

Published

on

Windows 11 Bug Makes AMD Processors Slow, Microsoft and AMD Find Solutions

Microsoft has just launched the latest Windows 11 operating system which is present as a free upgrade for Windows 10 users. However, since it has just been released, there are a number of bugs that appear in the OS.

If previously there were users who reported Windows 11 bugs that made RAM usage wasteful, now there are other reports that say that there is a bug that makes users with AMD processors experience a performance slowdown.

Quoted from GSMArena, it is stated that the bug causes AMD processors running Windows 11 to experience a performance slowdown for applications by 3-5% and Esports games reach 10-15% performance slowdown.

It was stated that this problem was caused by a bug that made Windows 11 prohibit AMD processors from using the preferred core feature optimally.

AMD itself has received the bug report and said that this problem mostly occurs to users who use AMD processors with 8 cores or more and TDP above 65W.

AMD will also work with Microsoft to solve this problem. It is predicted that this problem can be resolved by the end of October so that users are not harmed by the bug.

Continue Reading
Advertisement

Latest

how to use eyebrow soap how to use eyebrow soap
Beauty and Personal Care11 hours ago

Eyebrow soap: what is it for and how to use it

SHARE Fashions and aesthetic preferences are constantly changing and evolving. Unlike a few years ago, when the eyebrows were thin...

How to Copy Paste PDF Files How to Copy Paste PDF Files
PDF Tutorials12 hours ago

2 Ways to Easily Copy Paste PDF Files, Let’s Try it!

SHARE PDF is a type of document format that can only be opened using Adobe Reader software, a browser, or...

How to Trace Unknown Numbers, Immediately Know Who How to Trace Unknown Numbers, Immediately Know Who
Life Hack13 hours ago

How to Trace Unknown Numbers, Immediately Know Who

SHARE Have you ever received an unknown call and were afraid of being scammed? It’s easy! Just track it using...

How to burn and eliminate back fat How to burn and eliminate back fat
Weight Loss1 day ago

How to burn and eliminate back fat

SHARE Do you dare to put on that low-back blouse that you saw on the sideboard or do you still...

How to Restore Emoji Like Before How to Restore Emoji Like Before
Windows 112 days ago

How to Install New Windows 11 Insider Emoji on Windows 10

SHARE As previously reported, Microsoft updated Emoji in Windows 11 starting with Windows 11 Insider Preview Build 22478, then can...

How to quickly delete thousands of emails at once in Gmail How to quickly delete thousands of emails at once in Gmail
Internet2 days ago

How to quickly delete thousands of emails at once in Gmail

SHARE Your Gmail storage capacity is dying? The only way to get around this is to quickly delete hundreds of...

How to Schedule Live on Instagram, Can Be Set Up to 90 Days How to Schedule Live on Instagram, Can Be Set Up to 90 Days
Internet2 days ago

How to Schedule Live on Instagram, Can Be Set Up to 90 Days

SHARE Live Instagram is now getting more exciting regarding the schedule live feature. A feature that allows users to schedule...

How to burn belly fat How to burn belly fat
Weight Loss2 days ago

How to burn belly fat

SHARE Over the years, bad eating habits, pregnancies, sedentary life, menopause … Many and varied are the causes that make...

Oppo Reno 7 5G on the way. There is a technical specification Oppo Reno 7 5G on the way. There is a technical specification
Phones3 days ago

Oppo Reno 7 5G on the way. There is a technical specification

SHARE Oppo Reno 7 5G is the brand’s upcoming smartphone. The technical specification of the phone has appeared on the...

Realme Watch T1 on the way. What features will the new smartwatch offer Realme Watch T1 on the way. What features will the new smartwatch offer
Gadgets3 days ago

Realme Watch T1 on the way. What features will the new smartwatch offer

SHARE Realme Watch T1 is a new smartwatch from the Chinese brand. Renders have appeared on the network and these...

Advertisement

Categories

Trending

Copy link
Powered by Social Snap