T function in Excel

Purpose The T function used to check whether the given value is a text or not. If the tested value is a text then the formula returns the same value, otherwise returns an empty text string. Example 1– The T function mentioned hereunder tests different three values and returns results accordingly. Result: Syntax +T(value) where, […]

OFFSET Function in Excel

The OFFSET function returns a cell or range of cells from specified rows and columns of a selected cell or range of cells. 1– The OFFSET function below returns the cell that is 5th in the row below and 2 columns right to the reference cell i.e. B3. Result: Note that the function returns the single […]

Sum values specified by a year (Sum if by year)

To sum values specified by a year, The SUMIFS function will be used with two criteria. In our example, we will sum year wise sold units of a product. 1– Type ‘=SUMIFS’ and press ‘tab’ button. 2– Select values to sum against criteria. 3– Press ‘,‘ symbol and define the range to be tested against […]

Add different numerical values specified by criteria (Sum if between)

Use the SUMIFS function to add different numerical values specified by a set of conditions or criteria. For example, in our example, we will sum all those values which are greater than 100 and smaller than 200. Follow these steps to get the desired result: 1– Select any cell, type ‘=SUMIFS’ and press ‘tab’ button to […]

Create a new Workbook in Excel

A workbook in Excel is a group of worksheets that are used to organize, calculate & analyze various kind of related information. Open an Existing Workbook To open a workbook that you previously have been saved, follow these steps: 1– Go to the file tab, click open. 2– In the Recent section, your recent file will […]

Basics of Microsoft Excel [For beginners]

This section is for beginners with no knowledge of Excel. A workbook is a group of worksheets that are used to organize, calculate & analyze various kind of related information. Status Bar provides a quicker way to see the average, count, numerical count, minimum, maximum or sum of selected cells. Percentage Formula is used to get the relationship between two […]

Copyright © 2016 - 2018 Explainry.com | All Rights Reserved