View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Lars-Åke Aspelin[_2_] Lars-Åke Aspelin[_2_] is offline
external usenet poster
 
Posts: 913
Default commas in formulas

On Tue, 23 Dec 2008 06:46:03 -0800, Flipper
wrote:

b6/12,60,I know this is something I should know, but I don't...What function
does the comma perfomr inside a formula? Foir example: =PMT(B6/12,60,c6,d6)
Allan



The comma separated the different parameters. In your example there
are four parameters to the PMT function.
It is possible to choose another character, e.g. ; (semicolon), as
separator. If you don't have any separator, the function call would
look like =PMT(B6/1260c6d6) which is not possible to interprete
unambigously.

Hope this helpls / Lars-Åke