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
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.
Read more EOMONTH Function
Sometimes we need start date and end date of a month for our financial model. We can solve this problem by using EOMONTH Function.
Read more How to Get Start Date end Date of a Month Form a Date
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?
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