View Single Post
  #1   Report Post  
Roxypup
 
Posts: n/a
Default in excel formula the comma (,) is no longer accepted but the semi.

when entering formula in Excel the comma (,) is no longer accepted but the
semicolon (;) now has to be used.
Example:
Previous : =if(a2="Yes",a3+a4,b3+b4)
Now : =if(a2="Yes";a3+a4;b3+b4)

How do I change it back to using commas. I don't know how this has happened,
I just arrived at work one day and the changes has occured.