- By
**aliya** - Follow User

- 102 Views
- Uploaded on

Download Presentation
## PowerPoint Slideshow about ' Spreadsheet Functions' - aliya

**An Image/Link below is provided (as is) to download presentation**

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript

Functions

- Simple functions
- Array functions
- IF - logical functions

Function notation

- A function is a piece of computation that takes 1 or more arguments (data) and returns a value
- Function( arg1, arg2, arg3 )
- Sine(90)
- Max(100,200,120,-7)
- Sqrt( min(7+4, 9) )

Functions

- Simple functions
- Array functions
- IF - logical functions

Average program

Sum=0;

Count = 0;

for (each row R)

{ for (each column C in row R)

{ Sum=Sum+Sheet[R,C];

Count = Count+1;

}

}

Average = Sum/Count;

Other array functions

- Min
- Max
- Stdev - standard deviation
- Median
- Product - multiply them all together

Functions

- Simple functions
- Array functions
- IF - logical functions

If

- If ( test, trueVal, falseVal)

Review

- Functions - name with arguments
- Finding functions

- Array functions
- Sum(B6:D32)
- Average(F14:R75)

- IF - AND - OR

Download Presentation

Connecting to Server..