View Single Post
  #1   Report Post  
JohanS
 
Posts: n/a
Default Why do functions not allow commas to seperate arguments

Has anyone seen this before?

Functions are normally entered as =if(a210,"True","False")
My excel is not accepting formulas typed in this format, but rather shows me
the following when using the wizard: (not commas between arguments, but a
single space) IF(logical_test value_if_true value_if_false)
Even when using the wizard, it still returns error:
The formula you typed contains an error (same if I enter commas)