Posts

Showing posts from October, 2021

Use conditional formatting rules in Google Sheets

-
Image
  Cells, rows, or columns can be formatted to change text or background color if they meet certain conditions. For example, if they contain a certain word or a number. On your computer, open a spreadsheet in  Google Sheets . Select the cells you want to apply format rules to. Click  Format     Conditional formatting . A toolbar will open to the right. Create a rule. Single color : Under "Format cells if," choose the condition that you want to trigger the rule. Under "Formatting style, choose what the cell will look like when conditions are met. Color scale : Under "Preview," select the color scale. Then, choose a minimum and maximum value, and an optional midpoint value. To choose the value category, click the Down arrow  . Click  Done . Example A teacher can highlight test scores to see which students scored less than 80%. On your computer, open a spreadsheet in  Google Sheets . Select the test scores. Click  Format     Conditional...
Post a Comment
Read more

How to use the SUMIF Function?

-
Image
 MS Excel: How to use the SUMIF Function (WS) This Excel tutorial explains how to use the Excel SUMIF function with syntax and examples. Description The SUMIF function is a worksheet function that adds all numbers in a range of cells based on one criteria (for example, is equal to 2000). The SUMIF function is a built-in function in Excel that is categorized as a Math/Trig Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the SUMIF function can be entered as part of a formula in a cell of a worksheet. To add numbers in a range based on multiple criteria, try the SUMIFS function. Syntax The syntax for the SUMIF function in Microsoft Excel is: SUMIF( range, criteria, [sum_range] ) Parameters or Arguments range The range of cells that you want to apply the criteria against. criteria The criteria used to determine which cells to add. sum_range Optional. It is the range of cells to sum together. If this parameter is omitted, it uses range as the sum...
Post a Comment
Read more

WHAT IS VLOOKUP?

-
What is VLOOKUP?   VLOOKUP stands for ‘Vertical Lookup’. It is a function that makes Excel search for a certain value in a column (the so called ‘table array’), in order to return a value from a different column in the same row. This article will teach you how to use the VLOOKUP function. A VLOOKUP function exists of 4 components:  1. The value you want to look  up.  2. The range in which you want to find the value and the return value,  3. The number of the column within your defined range, that contains the         return value.  4. 0 or False for an exact match with the value your are looking for; 1 or True an approximate match. 
Post a Comment
Read more