% to Divide by 100

Description:
Google Sheets Trick: Using % to Divide by 100 (and More)
This episode explains how the percent symbol in Google Sheets can be used as a shortcut to divide numbers by 100 by simply appending % to a value (e.g., turning 38,848 into 388.48). It also demonstrates how to divide by 1,000 by applying % twice with parentheses, and shows how % can be combined with ARRAYFORMULA and SEQUENCE to generate lists like 0.01, 0.02, 0.03 by creating a sequence of integers and then appending %. The script also covers applying % to an entire range in a single array formula to divide every value in the range by 100.

00:00 Percent Divides by 100
00:26 Convert Big Numbers Fast
00:42 Divide by 1000 Trick
01:09 Sequence to Decimals
01:52 Percent on Ranges
02:10 Wrap Up and Subscribe