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!
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.
If the small green triangles do not appear in cells for some other reason, look at the Number Format box on the .
So, whenever you are writing a formula for numerical values, follow this simple rule: don't enclose numbers in double quotes unless you want them to be treated as text.
When using a number in an Excel formula, don't add any decimal separator or currency sign like $ or €.
I had the same problem many years ago and someone gave me this tip: In a blank cell type the number 1.
Select that cell and copy then select all of the area you want to update.
Numbers formatted as text values are another common reason for Excel formulas not working.
At first sight, they look like normal numbers, but Microsoft Excel perceives them as text strings and leaves out of calculations.
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.
Another possible solution is to multiply the values in the problematic column by 1 using a simple formula like .