What is logical test in excel?

Written by kazamraza no comments
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?

Add a Line Break in Cell Contents Using Excel Formula

Written by kazamraza no comments
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