Miscellaneous Articles: Excel and Google Sheets

We can find the SQUARE ROOT of a number with either the SQRT function or the POWER function with the corresponding power argument (1/2). The steps below will walk through the process. Figure 1: How to Find the Square Root of a Number Formula SQRT function: =SQRT(cell containing the number...

We can use the OFFSET function to sum a range of rows and columns from a reference cell. The OFFSET function eliminates the need for entering the desired range manually and the need for a complex formula. The steps below will walk through the process. Figure 1: How to Sum...

If you want to copy every nth row in Excel, you can accomplish this by combining several functions.  Copy a value from every nth row in Excel Copying values with a specific pattern in Excel can be done using the OFFSET and ROW functions. OFFSET function returns a reference to...

We can sum text values as numbers after we have ASSIGNED NUMBERS to the Values. We can do this with the INDEX, MATCH, and SUM functions. This is useful for the evaluation of a questionnaire. The steps below will walk you through the procedure. Figure 1: How to Sum Text Values...

We can use the TRANSPOSE function in combination with the IF Function to flip the orientation of a given range without having the zero snag. The steps below will walk through the process. Figure 1- How to convert rows to columns in a table without zeros using the TRANSPOSE and...

We use the COUNTIFS function and the IF function to develop a summary and display a course completion status based on a given set of data. The steps below will walk through the process. Figure 1- Final Result of using the COUNTIFS Function General Formula =IF(COUNTIFS(range1, criteria1, range2, criteria2), [value_if_true],...

While working with Excel, we are able to determine the number of values that satisfy one or more criteria within a specified range by using the COUNTIFS function.  This step by step tutorial will assist all levels of Excel users in generating a course completion summary with criteria. Figure 1....

Figure 1. of the And Function in Excel. Let's say we have to determine whether or not a number value can be found between two numbers, we can utilize the Excel AND Function. This tutorial will walk through the process Generic Formula =AND(val>MIN(num1,num2),val<MAX(num1,num2)) How to use the AND, MIN AND...

Excel allows a user to validate input with check mark using IF and COUNTIF function. This step by step tutorial will assist all levels of Excel users in validating the inputs with check marks based on the data from another table. Figure 1. Validate store input with the check mark...

Figure 1. of Value Within Tolerance in Excel. In order to determine whether or not a value is within our expected level of tolerance, we are going to utilize the ABS and IF Functions in Excel. This article will walk through the process Generic Formula =IF(ABS(actual-expected)<=tolerance,”Yes","No") The Excel “IF” function...