Updating excel www adatingnet com
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.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!
Most of us are used to separating function arguments with commas. The character you use to separate arguments depends on the List Separator set in your Regional Settings.
For example, in North America you would write ) and check what character is set as List Separator there.
And then, use exactly that character to separate arguments in your Excel formulas.
Can someone imagine using Microsoft Excel without formulas? And hardly anything could compare to the frustration caused by Excel formulas stop working all of a sudden.
When this happens, a bunch of questions immediately flash across your mind. Why doesn't this formula update its value automatically?