1 / 40

# Spreadsheet Functions - PowerPoint PPT Presentation

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

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

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

• 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