commas in formulas
 

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

commas in formulas
 

They separate the variables and other data needed for the formula to
work


--
Pecoflyer

Cheers -
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=43707

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

commas in formulas
 

I tend to think of it as a "to do list" for Excel.
Excel will perform task one which is before the fist comma, task two is
after the first comma, task three after the next comma, and so on. And Excel
may not have to perform all the tasks depending on what formula you have
setup, Excel may stop after it completes a specified task. Here is an
example in the form of an "If" formula.
IF(B10,B1,"help")
Excel reads it like this:
If cell B1 is greater than 0(task one) then give me results from B1(task
two) if not display help (task three).


"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