How to Create Custom Functions in Google Sheets

[tarekma7]

Have you ever wished your spreadsheet was as smart as you? Well, it may never be quite that smart, but with a little help from Google Scripts you can create your own custom functions and get it just a bit closer to that goal.
Google Sheets already has a lot of great features to handle numerical calculations, look-ups, and string manipulation, to name a few. However, you might find yourself needing to build lengthy or complex formulas that are difficult or impossible with the built-in options. If this is you, then you should consider taking the next step and building your own custom functions.
This guide will demonstrate how to accomplish this using a simple Google Script.

http://www.bitsdujour.com/software/how-t...deals-home