Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training onsite - How does the Dfunctions work
Resolved · Low Priority · Version Standard
Hi Felix
Thank you for your question.
Microsoft Excel includes Database functions that analyse data stored in lists or databases (e.g. DSUM, DAVERAGE, DMIN, DMAX). Each of these functions, referred to collectively as the Dfunctions, uses three arguments: database, field, and criteria. These arguments refer to the worksheet ranges that are used by the function.
I hope this helps.
Amanda
|
Excel tip:Generating Random NumbersTo generate a random number in Excel use the = RAND() function. |
We'll call during UK business hours
Server loaded in 0.08 secs.