excel training onsite - How does the Dfunctions work

Resolved · Low Priority · Version Standard

Wed 15 Aug 2007, 12:39 Delegate Felix said...

Felix has attended:
Excel Advanced course

How does the Dfunctions work

Please let me know

Felix

Wed 15 Aug 2007, 14:16 Trainer Amanda said...

RE: How does the Dfunctions work

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 Numbers

To generate a random number in Excel use the = RAND() function.

The value returned will always be between 0 and 1. To convert this to some other random value, you will need to multiply the result by the highest number you want to consider. For example, if you wanted a random number between 1 and 25, you could use the following code line:
= INT(25 * RAND()+ 1)

Since RAND() will always returns a value between 0 and 1 (but never 1 itself), multiplying what it returns by 25 and then using the Integer function INT on that result will return a whole number between 0 and 24.

Finally, 1 is added to this result, so that x will be equal to a number between 1 and 25, inclusive

View all Excel hints and tips

excel training onsite - How does the Dfunctions work

How does the Dfunctions work

RE: How does the Dfunctions work

Excel articles

Excel tip:

Generating Random Numbers