Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
So many commas | Excel Worksheet Functions | |||
delete commas in spreadsheet but not in formulas | Excel Discussion (Misc queries) | |||
commas in cells | Excel Discussion (Misc queries) | |||
help commas before data | Excel Discussion (Misc queries) | |||
Missing commas | Excel Worksheet Functions |