- 77 Views
- Uploaded on
- Presentation posted in: General

Spreadsheet Functions

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 - - - - - - - - - - - - - - - - - - - - - - - - - -

Spreadsheet Functions

- Simple functions
- Array functions
- IF - logical functions

- 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) )

- Simple functions
- Array functions
- IF - logical functions

Sum=0;

for (each row R)

{ for (each column C in row R)

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

}

Sum=0;

for (each row R)

{ for (each column C in row R)

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

}

Sum=0;

for (each row R)

{ for (each column C in row R)

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

}

Sum=0;

for (each row R)

{ for (each column C in row R)

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

}

Sum=0;

for (each row R)

{ for (each column C in row R)

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

}

Sum=0;

for (each row R)

{ for (each column C in row R)

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

}

Sum=0;

for (each row R)

{ for (each column C in row R)

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

}

Sum=0;

for (each row R)

{ for (each column C in row R)

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

}

Sum=0;

for (each row R)

{ for (each column C in row R)

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

}

Sum=0;

for (each row R)

{ for (each column C in row R)

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

}

Sum=0;

for (each row R)

{ for (each column C in row R)

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

}

Sum=0;

for (each row R)

{ for (each column C in row R)

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

}

Sum=0;

for (each row R)

{ for (each column C in row R)

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

}

Sum=0;

for (each row R)

{ for (each column C in row R)

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

}

Sum=0;

for (each row R)

{ for (each column C in row R)

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

}

Sum=0;

for (each row R)

{ for (each column C in row R)

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

}

Count=0;

for (each row R)

{

for (each column C in row R)

{

Count=Count+1;

}

}

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;

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

- Simple functions
- Array functions
- IF - logical functions

- If ( test, trueVal, falseVal)

- Functions - name with arguments
- Finding functions

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

- IF - AND - OR