commas in formulas

F

Flipper

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
 
L

Lars-Åke Aspelin

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
Click to expand...


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
 
E

evoxfan

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(B1>0,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).
 
Top