Making numbers while the sun shines
Here, you'll use
ISNUMBER() to find which cells are really numbers, then N() to convert all values in a column to be numbers.本練習屬於課程
Google Sheets 中級
練習說明
A wind speed value is not really a number.
- In
H2, callISNUMBER()to check if cellB2is a number. - Copy the formula down to
H20. - In column
I, useN()to convert the values from columnBto numbers. - In column
J, useISNUMBER()to confirm that columnIcontains only numbers.
