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.
