| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
Not a 100% sure how well XL honors them, but check your Windows
'Regional Settings.' -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get the formula bar in excel 2003 | Excel Discussion (Misc queries) | |||
| How do I prevent Excel from plotting a cell w/ a formula as a "ze. | Charts and Charting in Excel | |||
| How do I prevent Excel from plotting a cell w/ a formula as a "ze. | Charts and Charting in Excel | |||
| Excel How do I create a comma delineated xls file to a comma delineated. | Excel Discussion (Misc queries) | |||
| How do I create a formula in Excel that will countif or sumif bef. | Excel Worksheet Functions | |||
Linear Mode
