Arithmetic with strings

Question

Arithmetic with strings

SheetJSDev opened this issue 2 years ago · 3 comments

SheetJSDev commented 2 years ago

Set cell A1 to the string "1x" (no quotes) and cell B1 to the number 2. Enter the formula =A1*B1 in cell C1.

Cell C1 will have the value "2*NaN"

Answer 1 · 2022-05-18T06:44:58.000Z

1x is not number

Answer 2 · 2022-05-18T06:52:54.000Z

The expected result is some sort of NaN or error. Excel / Google Sheets generates a #VALUE! error. Numbers shows the error message "The operator “*” expects a number, but cell A1 contains a string.". "2*NaN" looks like a hybrid of numeric and text interpretations

Answer 3 · 2022-05-18T06:54:54.000Z

yep, will fix this