answersLogoWhite

0

No, it has five arguments. Two of them are optional.

The syntax for the PMT function is:

PMT(interest_rate, number_payments, PV, FV, Type)

The FV and Type arguments are optional.

User Avatar

Wiki User

10y ago

What else can I help you with?

Related Questions

In Excel payment function what are the 2 kinds of arguments?

That could be answered in different ways, depending on what you mean by kinds of arguments. There are mandatory and optional arguments. There are 4 numeric ones and 1 logical one.


What is meant by arguments in c?

Arguments appear in functions and in function calls. Arguments passed to a function are known as actual arguments. The arguments used by the function are known as the formal arguments. In C, all arguments are passed by value, such that the formal argument is a copy of the actual argument.


How will you pass arguments to a function in c plus plus?

If you have this function: int add(int x, int y) { return x + y; } you would pass the arguments when calling the function in the () like this: add(4, 7); 4 & 7 would be the arguments.


What is a general syntax of all formulas in Excel?

You start with the equals sign. After that there is no fixed rule, as formulas are completely different to each other. If you are using functions then there are some rules. First there is the name of the function. After that you have an opening round bracket. Most functions will have arguments in them, and some will not. The square brackets used below indicate that there may or may not be arguments, but are not part of the function. If there are any arguments, they need to be put inside the round brackets. Finally there will be the closing round bracket.=function_name([arguments])This is how the SUM function can work:=SUM(A2:A20)You can also have formulas with no functions. They would include values and cell references:=20+C5-34*4


What function do you use for 3 x 4?

To multiply 3 by 4 you do not need to use a function. You can do it as a straight calculation. However, Excel does provide a function that could be used to do it. The function is called PRODUCT and will multiply all numbers in it. In this case it could be used as follows: =PRODUCT(3,4)


How do you use the REPT function in Microsoft Excel?

The REPT function repeats a piece of text a set amount of times. =REPT("A",4) The above function will repeat the A four times. The result would be: AAAA


What is the function of pre-defined function LEN in Excel?

The LEN function returns the length of the specified string.=LEN(text)text is the string to return the length for.EXAMPLE:=LEN(word) will return the value of 4.


How does Excel dispay year?

Excel can display the year as a number. You can get it to display in different ways as part of a full date, such as having 2 or 4 digits to represent it. There is also a YEAR function, to extract just the year from a full date, which is then displayed as a number.


What are the part and environment of excel?

4


What is passing parameter in c plus plus?

Parameter passing is where we call a function with arguments. A parameter is simply another name for an argument.Examples:void f (void); // no arguments expectedvoid g (int); // one argument expectedvoid h (int, int=2); // two arguments expected (second argument is optional, defaulting to 2)f (); // okf (1); // error -- no argument expectedg (); // error -- one argument expectedg (2); // okg (0, 1); // error -- too many argumentsh (); // error -- at least one argument expectedh (4); // ok -- invokes h (4, 2)h (4, 5); // okh (4, 5, 6); // error -- too many argumentsArguments specified by a function are known as formal arguments. Arguments passed to the function are known as actual arguments. The actual arguments are always passed to the function by value unless the formal argument is a reference in which case the address of the actual argument is passed. If the formal argument is a pointer, it is passed by value. However, given that pointer values are memory address, this is the same as pass by reference. The only difference is that pointers may be null whereas references can never be null. If "no object" is a valid argument, the function should specify a pointer argument, otherwise it must specify a reference argument. Not all languages support references (C++ does, but C does not).


What is the sum of 7 and 4 in Excel spreadsheet?

The sum of 7 and 4 is 11, whether in an Excel spreadsheet or anywhere else. In Excel the formula would be =SUM(4,7) or =4+7 or =(B12+B13) if the values 7 and 4 were in cells B12 and B13.


How many kms does a 96 excel do?

4