Posts

Showing posts from June, 2016

Miracle of IFERROR Function in MS Excel

Image
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:

For empty value, it will be an empty string (“”) not an error.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.



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:

QuickBooks Error 1306QuickBooks Error: -6144, -301QuickBooks Error 1606QuickBooks Error H101, H202, H303, and H505Income 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 i…