Spreadsheet functions
This presentation is the property of its rightful owner.
Sponsored Links
1 / 40

Spreadsheet Functions PowerPoint PPT Presentation


  • 58 Views
  • Uploaded on
  • Presentation posted in: General

Spreadsheet Functions. 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) ).

Download Presentation

Spreadsheet Functions

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


Spreadsheet functions

Spreadsheet Functions


Functions

Functions

  • Simple functions

  • Array functions

  • IF - logical functions


Function notation

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


Using functions

Using functions


Using functions1

Using functions


Finding functions

Finding functions


Finding functions1

Finding functions


Finding functions2

Finding functions


Finding functions3

Finding functions


Finding functions4

Finding functions


Finding functions5

Finding functions


Functions1

Functions

  • Simple functions

  • Array functions

  • IF - logical functions


Spreadsheet functions

Sum


Sum program

Sum program

Sum=0;

for (each row R)

{ for (each column C in row R)

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

}


Sum program1

Sum program

Sum=0;

for (each row R)

{ for (each column C in row R)

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

}


Sum program2

Sum program

Sum=0;

for (each row R)

{ for (each column C in row R)

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

}


Sum program3

Sum program

Sum=0;

for (each row R)

{ for (each column C in row R)

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

}


Sum program4

Sum program

Sum=0;

for (each row R)

{ for (each column C in row R)

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

}


Sum program5

Sum program

Sum=0;

for (each row R)

{ for (each column C in row R)

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

}


Sum program6

Sum program

Sum=0;

for (each row R)

{ for (each column C in row R)

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

}


Sum program7

Sum program

Sum=0;

for (each row R)

{ for (each column C in row R)

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

}


Sum program8

Sum program

Sum=0;

for (each row R)

{ for (each column C in row R)

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

}


Sum program9

Sum program

Sum=0;

for (each row R)

{ for (each column C in row R)

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

}


Sum program10

Sum program

Sum=0;

for (each row R)

{ for (each column C in row R)

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

}


Sum program11

Sum program

Sum=0;

for (each row R)

{ for (each column C in row R)

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

}


Sum program12

Sum program

Sum=0;

for (each row R)

{ for (each column C in row R)

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

}


Sum program13

Sum program

Sum=0;

for (each row R)

{ for (each column C in row R)

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

}


Sum program14

Sum program

Sum=0;

for (each row R)

{ for (each column C in row R)

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

}


Sum program15

Sum program

Sum=0;

for (each row R)

{ for (each column C in row R)

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

}


Count

Count


Count program

Count program

Count=0;

for (each row R)

{

for (each column C in row R)

{

Count=Count+1;

}

}


Average

Average


Average program

Average Program


Average program1

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

Other array functions

  • Min

  • Max

  • Stdev - standard deviation

  • Median

  • Product - multiply them all together


Functions2

Functions

  • Simple functions

  • Array functions

  • IF - logical functions


Spreadsheet functions

If

  • If ( test, trueVal, falseVal)


Spreadsheet functions

AND


If with and

IF with AND


Review

Review

  • Functions - name with arguments

    • Finding functions

  • Array functions

    • Sum(B6:D32)

    • Average(F14:R75)

  • IF - AND - OR


  • Login