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.
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.
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.
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.
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.
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.
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.
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...
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
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
SHARE Do you dare to put on that low-back blouse that you saw on the sideboard or do you still...
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
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
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
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
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
SHARE Realme Watch T1 is a new smartwatch from the Chinese brand. Renders have appeared on the network and these...
- Beauty and Personal Care
- Blog Tutorials
- Life Hack
- Mobile Tutorials
- MS Excel
- MS Outlook
- MS Word
- PC Tutorials
- PDF Tutorials
- Social Media
- Weight Loss
- Windows 10
- Windows 11
Phones2 years ago
Apple iPhone 11 (2019) – Release, Info, Leaks, Rumors
Phones2 years ago
Huawei New Operating System is HarmonyOS [ Officially ]
Tech2 years ago
Levi’s Bluetooth Jacket Lets You Control Your Smartphone
News2 years ago
Belle Delphine bath water – Instagram Model Sells Used Bathwater For 30$ To Their Loyal Followers