## How to use SLN function in excel for depreciation calculation

Excel version in which SLN function can work: SLN function will work in Excel for Office 365 Excel for Office 365 for Mac Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel for Android phones Excel Mobile Excel Starter 2010. About SLN function in excel: SLN is a worksheet financial function, this will calculate straight line depreciation of an asset…

## How to use EXACT function in Microsoft Excel

Excel version in which EXACT function can work: EXACT function can work in all of the latest version of Microsoft office. About EXACT function in excel: It compares two cells in excel, result will be TRUE if values in both cells are exactly same. Result will be FALSE if values are not same. Syntax for EXACT Function: =EXACT(text1, text2) Parameters: text1 and text2 = Two cell values to compare. It is a case sensitive when comparing it with two strings.…

## Subtotal Formula in Microsoft Excel

Excel version in which SUBTOTAL function can work: Excel SUBTOTAL formula can work in all of your latest version of Microsoft office. About SUBTOTAL function in excel: Subtotal Formula helps to find out subtotal of the numbers in a column from the database. It is a built in function in Excel, that can be categorize as Math or Trig function. It can be used also as a worksheet  function. This function can be clubbed with other formula also. Syntax for…

## Using VALUE Function in Excel

Excel Version in which VALUE functions can work: Excel VALUE function works in all Excel Versions. About Excel VALUE function: The Microsoft Excel VALUE formula converts a text value that represents a number to a number. It is a built in String or Text function in excel. It also can be used as a worksheet function. Syntax for VALUE: =VALUE(text) Parameters: text : The cell to convert to a number.If text is not a number, the VALUE formula will return #VALUE!. Using…

## AREAS function in excel

Version in which AREAS function can work: AREAS function in excel will work in Excel for Android phones Excel Mobile Excel Starter Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets. About AREAS function in excel: The Excel AREAS function returns the number of areas in a reference. The area can be a range of contiguous cells or a single cell.…

Version in which ADDRESS function can work: Excel ADDRESS function will work in Excel for Android phones Excel Mobile Excel Starter Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets . About excel ADDRESS function: The Excel ADDRESS function returns a text  of cell address based on the given row and column number. Syntax for excel ADDRESS Function: =ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])…

## How to use Excel Replace function

Version in which REPLACE function can work: Excel REPLACE function will work in Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel Starter Excel Mobile Excel for Android phones. About REPLACE function: The Excel REPLACE function replaces the text based on the location which we provide in the formula. Syntax for excel REPLACE Function: =REPLACE(old_text,start_num,num_chars,new_text) Parameters: old_text: The text to…

## How to use Excel Text function

Excel version in which TEXT function can work: Excel TEXT function will work in Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel Starter Excel Mobile Excel for Android phones. About TEXT function: The excel TEXT function converts the cell into a text format in a specified format. It is a built in worksheet function. You can use this function as…

## How to use Excel Left Right Function

Excel version in which LEFT and RIGHT function can work: Excel LEFT RIGHT function will work in Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel Starter Excel Mobile Excel for Android phones. About excel LEFT and RIGHT function: LEFT and RIGHT function extracts a letter from a word starting from the left-most character or right most character respectively. LEFT and RIGHT is…

## Excel NOT function

Excel version in which NOT function can work: Excel NOT function will work in Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel Starter Excel Mobile Excel for Android phones. About excel NOT function: Excel NOT function is a logical function, it checks a logical value and returns the opposite logical value. If input logical value is TRUE it will return the…

×