Don{ald} O. Woodall wrote:

>>WRT IBMWorks Help - after peeling off a spreadsheet template - goto 
>>HELP|Procedures|Search "functions"|Function List to get a
full listing 
>>of functions available.
>>    
>>
>
>     Oh, I wandered around the help function for a while, found the
>listing of functions, but no where could I find anything telling me how to
>enter a function into a cell and get it to work!
>  
>
[See below]

>>In my example I could have used Average|Avg in lieu of using 
>>average=total/count (of items), which lets you reuse the count value 
>>elsewhere.
>>    
>>
>>It's good to learn something new every day!
>>    
>>
>>P.S. to just sum a [partial] column select the range of cells, then 
>>click the Sigma ICON on the toolbar [between right-justified and Graph].
>>    
>>
>
>     Yes, and there is alway a limitless list of things
>to learn each day.
>
>     Thanks Mike
>
Hi Don,

Following paste as copied from the HELP :

     Using Functions
          
           A function  is a frequently performed
           calculation that is built into the spreadsheet. 
           Functions are shortcuts for complicated
           formulas.
          
           IBM Works has 8 categories of functions for a
           total of 54 individual functions that allow a
           range of calculating options.
          
           All of the functions have the same syntax:  the
           function consists of the function name followed
           by a set of parentheses; within the parentheses
           are one or more arguments separated by
           commas.
          
           An argument  is a value that the function
           operates on.  It can be a character or numeric
           value, a cell or cell range, or an expression.
          
           _*_Entering_functions_

    *_       1. Select the cell to contain the function and
        enter "=" to begin a formula.
           2. Type in the function and insert cell
        references by typing or by clicking the appropriate
        cells.
           OR
           1. Select "Paste Function" from the Edit menu.
           2. Select from the function category buttons. 
        The associated functions will be displayed.
           3. Select the function.
           4. Select Paste.  The function will appear in the
        cell edit box at the insertion point.  Insert cell
        references by typing or by clicking the appropriate
        cells. 

-- 
Regards,
Mike

Failed the exam for
--------------------
MCSE - Minesweeper Consultant and Solitaire Expert
--------------------
[ISP blocks *.exe, *.cmd, *.com, *.bat, *.reg attachments]
[Please use zipped versions of above]



------------------------ Yahoo! Groups Sponsor --------------------~--> 
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/E8folB/TM
--------------------------------------------------------------------~-> 

 
Yahoo! Groups Links

 To visit your group on the web, go to:
    http://groups.yahoo.com/group/os2user/

 To unsubscribe from this group, send an email to:
    os2user-unsubscribe{at}yahoogroups.com

 Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 




---