Updating charts in excel
If that doesn't work, you might have to create a new column, manually input the data (e.g.
copy your text-numbers to Notepad, and then back to a new column), and delete the broken column.
Comma is the default list separator in North America and some other countries.
In European countries, comma is used as the decimal symbol and the list separator is usually set to semicolon.
As soon as you remove "" surrounding 1 and 0 in the above formula, Excel will treat the outputs as numbers and they will be calculated correctly.
As you know, the arguments of Excel functions are entered within the parentheses.Please see How to highlight and match parenthesis pairs for more information.All Excel functions have one or more required arguments.At first sight, the following formula appears to be working fine: But the problem is the returned 1's and 0's are text values, not numbers!And if you reference any cells with the above formula in other formulas, those cells won't be included in calculations.
When referring to other worksheets or workbooks that have spaces or non-alphabetical characters in their names, enclose the names in 'single quotation marks'.