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?

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

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