SUM is one of the most commonly used function in Excel , which is used to add the numbers in the argument. In this article you can learn the syntax and how to use excel SUM formula. You can use this formula to add the numbers in a range by selecting a range reference in … Read more
In excel formula the reference can be given to different cell. The reference is just like giving address of the cell. The formula will take the value of the cell mentioned in the reference. The reference can be relative reference or absolute reference. In this article i will explain how to use relative and absolute … Read more
In Microsoft Excel, if the inputs are not valid, then the formula will show the error. This error may be like, #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!. To avoid this error, you can use the “ISERROR” or “IFERROR” formula. “IFERROR” is simple and easy, but this function is available only in Excel 2007 … Read more