How-To Geek on MSN

Document formulas in Excel like code with N() function

The simplest way to start documenting Excel formulas like a coder is by using the N () function. Although its primary job is to convert non-numeric values into numbers, it has a hidden quirk: because ...
Android Police

How to create and import named functions in Google Sheets

SUM and VLOOKUP are only a few of the functions Google Sheets offers for using mathematical formulas. When dealing with complex calculations, Apps Script can help you create a custom one. It's a ...