Why do functions not allow commas to seperate arguments
Tech-Archive recommends: Fix windows errors by optimizing your registry
Has anyone seen this before?
Functions are normally entered as =if(a2>10,"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)
.
Relevant Pages
- Re: Writing to a CSV file
... This is a data entry form, there will not be any data modification or ... > the posted code fails to place commas between the values ... > This isn't really Excel format. ... > formatted text or other features of excel at all... ...
(microsoft.public.dotnet.languages.csharp) - RE: Mail Merge Formating Issues
... may want to copy the data first to a new worksheet using the paste special ... I have fomated the cells in Excel but when the merge to Word they are not ... EX - Number are formated in Excel with commas but merge to Word with no ... What do I need to do to get this merge to format properly in Word? ...
(microsoft.public.excel.misc) - RE: Simple formulas dont work (very very weird)
... That does not work, it says invalid format. ... I am guessing this has something to do with the commas in the formula. ... excel formulas, so this is really bothering me (especially since I can't type ... But if I double-click on the cell (as if I am going to edit the ...
(microsoft.public.excel.newusers) - All functions that use commas arent working!
... That does not work, it says invalid format. ... I am guessing this has something to do with the commas in the formula. ... excel formulas, so this is really bothering me (especially since I can't type ... But if I double-click on the cell (as if I am going to edit the ...
(microsoft.public.excel.worksheet.functions) - Excel wont let me type a formula using commas!
... That does not work, it says invalid format. ... I am guessing this has something to do with the commas in the formula. ... excel formulas, so this is really bothering me (especially since I can't type ... But if I double-click on the cell (as if I am going to edit the ...
(microsoft.public.excel) |
|
