## Add a Line Break in Cell Contents Using Excel Formula

Written by kazamraza
Classified in : Excel Formulas, Text Functions Tags : none

Inserting a line break in Excel cell contents helps us, when

• We are writing very long formulas
• The length of content exceeding cell/column width

We can insert line break by two methods.

While writing long formulas use Alt + Enter to insert a line break and to add a line break in text string we use CHAR(10).

In the following example I use CHAR(10) and click Wrap Text (Alt + H + W) from Home Tab.

Read more Add a Line Break in Cell Contents Using Excel Formula

## EOMONTH Function

Written by kazamraza
Classified in : Excel Formulas, Date & Time Functions Tags : none

Returns the serial number for the last day of the month that is the indicated number of months before or after start_date. Use EOMONTH to calculate maturity dates or due dates that fall on the last day of the month.

## What is logical test in excel?

Written by kazamraza
Classified in : Excel Formulas, Logical Functions Tags : none

Logical test means a condition when evaluated by computer whose result/outcome is true or false, there is no third option, for example if a student secures more than 45 marks it is considered as pass otherwise fail.

In Excel a single IF function (IF(logical_test, value_if_true, value_if_false)) evaluate only one logical test at one time, if we have more than one conditions/logical tests, then we use AND function or OR function along with IF Function.

Read more What is logical test in excel?

## Find the Last Row of data in Excel Using INDEX and COUNTA

Written by kazamraza
Classified in : Excel Formulas, Lookup Functions Tags : none

Sometime we have a requirement that we want to fetch data from last cell in a column. This task can be achieve by using

• INDEX Function (Return the value or reference of the cell at the intersection of particular row and column in a give range)
• COUNTA Function (Count the number of cell in a range that are not empty)

Read more Find the Last Row of data in Excel Using INDEX and COUNTA