Miscellaneous Articles: Excel and Google Sheets

All resources related to Miscellaneous for Excel and Google Sheets.

Miscellaneous

How to Find the Square Root of a Number
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...
How to Sum Every 3 Cells
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...
Copy Value from Every nth Row
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...
Learn How to Sum Text Values Like Numbers in Excel
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...
Transpose table without zeros
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...
Course completion status summary
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],...
Course completion summary with criteria
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....
Value is between two numbers
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...
How to Validate Input with a Check Mark in Excel
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...
Determine If a Value Is Within a Tolerance in Excel
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...
1 2 6 7