Pages

Tuesday, June 21, 2016

Miracle of IFERROR Function in MS Excel

In this blog, I am going to share my knowledge on iferror() function. Let’s take an example to understand in a better way.

iferror() Function

It is one of the most useful logical function of MS Excel which worked on logical values (True and false). It checks the initial expression and returns an error or we can say returns the second argument. It comes under top 10 formulas of MS Excel. This function is not available on earlier versions of MS Excel 2007. The basic syntax of this function is:

IFERROR(value, “value_if_error”)

Where:

  • value: Expression for testing.
  • Value_if_error: Error value returned by the function. It evaluated the following error types: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!.

Important Notes:

  1. For empty value, it will be an empty string (“”) not an error.
  2. If user won’t write any message in value_if_error string (“”) then, no error message will be displayed.

We have numbers here, Numerators and Denominators. In the last row, we have total sum of these numbers.


 
78 is the sum of 5+15+22+36 i.e. auto sum function doesn’t add any value for characters. When you will apply the formula “a/b” in column 3 then, the result will be like this:



You can see two errors in column 3. One is #Div/0! And other is #value!

The sum is also showing the error because sum function cannot add these errors. It is a small data but, think about the large data. It is very tough to find the error in a large amount of data and not possible to fix the problem manually. In this case, IFERROR function can be very important.

Now, I will perform the same operation with iferror function: iferror(B5/C5, “”) and press enter. You can write the error message in the quote (“”) sign or leave it blank.


 
I leave it blank and get the above output. With the help of iferror function, it is easy to value related errors in MS Excel.

Sometimes, functions don’t work in MS Excel due to many reasons like registry problem, corruption in MS Excel file etc. Registry is a huge database where most of the system errors come from. So, you should clean the corrupt registry on a daily basis.

If there is a corruption in MS Excel file, then you can use open and repair option or a reliable third-party tool to fix the corruption.

Conclusion: I described the use of iferror() function with appropriate example. So use this function to test the error and replace it with the meaningful result. Share your thoughts on this post via your valuable comments. 
READ MORE - Miracle of IFERROR Function in MS Excel

Wednesday, June 1, 2016

5 Common QuickBooks Errors & Solutions

QuickBooks are used by several businesses, but most of them cannot use the program correctly. You might have lost some of your valuable data due to some errors in the QuickBooks. You need not fret! In this blog, we will discuss about the 5 most common QuickBooks errors and their solutions.

You might have encountered different QuickBooks errors that has affected the information you had saved on the QuickBooks file. In this post we will be discussing the common errors and how to resolve them. Here are the 5 common QuickBooks errors:

  1. QuickBooks Error 1306
  2. QuickBooks Error: -6144, -301
  3. QuickBooks Error 1606
  4. QuickBooks Error H101, H202, H303, and H505
  5. Income Account: The specified Account does not exist in the list

Let us discuss the errors and their solutions in detail –

  • QuickBooks Error 1306

You might have noticed that when you tried to install any update for QuickBooks, an error 1306 is displayed on the screen, which reads - Another application has exclusive access to [filename].

This error is common and appears when another process of the program is still running on the background.  Even if you have closed the QuickBooks program, certain parts of the program process continues to run and is visible in Windows Task Manager window. This error may also occur because of a damaged installation of the program.

How to fix it?
Even before you try to fix the error that has appeared on the screen while attempting to install program updates, you must close all the processes of the QuickBooks. And, in case the error occurs because of a damaged installation, you must get the program repaired. To repair, here are the steps that needs to be followed –

  1. Close the QuickBooks program 
  2. Reboot.bat. file
  3. Restart the computer and the QuickBooks program
  4. In case this error still appears, try and repair the existing installation
  5. If the error still persists, uninstall the program

Note:  If the problem persist after following these steps, contact an expert.

  • QuickBooks Error: -6144, -301

Sometimes when you are trying to access the QuickBooks company file, an Error 6144, -301 occurs. This error is an indication that the company files is corrupt. In order to fix it, you will have to restore the most recent backup. If you are still unsure or unable to do it, get in touch with a data service team or even use a third part tool.

  • QuickBooks Error 1606:

While trying to install QuickBooks, you might have seen this error message on the screen. There isn’t anything to whine when you see this error message. It is essential for you to know that such error messages appear when the Windows user account is corrupt or the listed network location on the error is not available.

How to fix it?
To resolve this problem, you can install the program through the Admin user account.  Or else you can follow the steps mentioned below –

  1. Restart your computer
  2. Sign-in to the computer using the Windows admin username and password
  3. Try installing the program through the admin account 
    • Use selective start-up mode to restart the computer. Reinstall the QuickBooks program
Note: Choose the appropriate option from above list.

  • QuickBooks Error H101, H202, H303, and H505:

When you are trying to open QuickBooks company file in the multi-user mode, you might have encountered Error H101, H202, H303, and H505. This error often appears when you either try to work with a file located in another computer, and the copy that you are trying to open isn’t able to reach the server on that computer. Or, when you try to access the file on another computer that requires additional setup and installations.  To fix this error, you need to turn off the hosting on all the machines and turn it on a single machine.

How to fix it?
In order to fix it, you will have to turn on the hosting for a single computer and turn it off for the rest. After that follow the below mentioned steps -

  1. Open the program and go to File > Utilities
  2. If the Host Multi-User Access option appears in the list, this means that this computer is not hosting the company file and you can move on to the next computer
  3. If Stop Hosting Multi-User Access appears, select it and click on the Yes tab for confirmation
  4. Restart the computer and repeat the same process in rest of the computers
  5. After completion of this process, turn on the hosting on the computer that is assigned as the server


  • Income Account: The specified Account does not exist in the list:

When you are importing an item in QuickBooks, you must have come across this error message that appears in the CSV error log. This error message means that the income account that you have selected on an item has not still been created in QuickBooks. How to fix:

You can resolve it by adding that particular account to the chart of accounts and import again.
 Click on Chart of Accounts.

  1. Go to Account->New.
  2. Select Income and click on Continue button.
  3. Now fill the details for new account and click Save & Close option.

Conclusion: These are the 5 common QuickBooks errors and their solutions. It is essential to know the exact reason of the errors so that you can  fix  them. Hope you have found this blog helpful . Keep reading and share your thoughts on this blog by leaving a comment below.

READ MORE - 5 Common QuickBooks Errors & Solutions
Related Posts Plugin for WordPress, Blogger...