#1   Report Post  
Posted to microsoft.public.excel.misc
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
So many commas Alan[_5_] Excel Worksheet Functions 2 May 24th 07 07:44 PM
delete commas in spreadsheet but not in formulas cynwalker Excel Discussion (Misc queries) 2 January 24th 07 01:05 AM
commas in cells DEE Excel Discussion (Misc queries) 9 December 22nd 06 08:15 AM
help commas before data James Excel Discussion (Misc queries) 5 March 8th 05 06:25 PM
Missing commas Steve Mock Excel Worksheet Functions 1 January 23rd 05 08:57 AM


All times are GMT +1. The time now is 05:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"