Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

ResolvedVersion 2003

Fri 31 Oct 2008, 16:11 Delegate Edward said...

Edward has attended:
Excel Intermediate course

Excel

what is a nested function?
what is the capital of poland?

Mon 3 Nov 2008, 12:03 Trainer Andrew said...

RE: excel

Hi Edward

Thanks for your questions.

a nested function is a term used to describe a function which uses another function as a value. For example the following would apply the round function to the results of a sum function:

=ROUND(SUM(A1:A5),1)

and the capital of Poland is Warsaw.

Hope this helps - let us know if you have any other MS Office questions.

Kind regards,
Andrew

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Naming and Using Constants

Constants make calculations easier so worksheets are more easily understood. Constant values also need to be given relevant and memorably names. It is also easier to change the value of a constant.

For example:
Instead of entering 17.5% in each cell when you generate a VAT amount you could name a Constant "VAT" and assigning a "0.175" value to it. To do this:

From the 'Insert' menu select 'Name', then select 'Define'.

Enter the constant

View all Excel hints and tips

Excel

Excel

RE: excel

Excel articles

Excel tip:

Naming and Using Constants