Скачать или смотреть Use the ISERROR function for error solving (Excel 2016)

In cells B1:B6 set the values of cell range A1:A6.
If their values cannot be represented by a number then set the value in the corresponding cell of the B column to 0.
You can use the conditional functions IF, ISERROR, IFERROR and the VALUE function.
Then calculate the sum of the cell range B1:B6 in cell B8.Want more? Then download our TEST4U demo from https://www.test4u.eu/en/demo
TEST4U provides an innovative approach to learning. Ignore the boring e-courses and use a new, interactive tool like 700 000 satisfied users did.
TEST4U is an automated test which cooperates with the actual applications and can be used to prepare the students for certification exams (e.g. Microsoft-Certiport, ECDL/ICDL, DIPLOMA etc.) and train and assess employees.
More on https://www.test4u.eu/en/demo