Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pmt formulaes and IFs

Pmt formulaes and IFs

ResolvedVersion 2003

Thu 25 Feb 2010, 00:10 Delegate Ed said...

Ed has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

Pmt formulaes and IFs

I created an if statement in excel 2003 and displayed too many arguements can you pls let me know if this is a common problem? and perhaps let me know how to get around this problem?

Mon 1 Mar 2010, 09:08 Trainer Stephen said...

RE: pmt formulaes and IFs

Hi Ed

Thanks for your question

Creating too many arguments in a function is indeed a common problem and can have a number of causes. The If function should have three arguments, each separated by a comma, thus there should be two commas in the function.

The best way to avoid this mistake, is where possible to use the paste function tool, (Insert-Function). This will guide you through the process of building the function and will help minimise errors.

Regards

Stephen

Mon 8 Mar 2010: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Use the SUBTOTAL function in Excel

You can create subtotals in your spreadsheet using the SUBTOTAL function, which looks like this:

=SUBTOTAL(9,cell:cell)

9 represents the function being used (SUM), followed by the range of cells the function is operating on.

The neat thing about using the Subtotal function is that if you have used it several times in the same column or row, clicking on the AutoSum button at the end of the column or row will make Excel add only the results of cells containing the Subtotal function in that column or row.

View all Excel hints and tips

Pmt formulaes and IFs

Pmt formulaes and IFs

RE: pmt formulaes and IFs

Excel articles

Excel tip:

Use the SUBTOTAL function in Excel