Menu
Is it possible to define a function in Google Spreadsheets that can be used in any cell?
It would be helpful if I could define and use functions that refer to other cells in the same way that I can use native functions, e.g. by entering =myfunction(C1, C2, C3)
863
You can use Google Apps Script to write a custom function, then use it in Google Sheets just like a built-in function. The below quickstart sample creates a custom function that calculates the sale price of discounted items.
Similar to MS Office, Google docs allows you to create doc, ppt and xls with similar functions such as inserting images and tables, changing ppt background themes and adding formulas in spreadsheets with super subscript and subscript for Mathematical documents.
In Sheets, navigate to Data > Named functions > Add new function > enter details > Next > Create. You can then enter your custom formula into a Sheets' cell. Named functions created in a Sheets file are available only in that file.
Yes - there's a tutorial. Just use javascript functions by name in your spreadsheet. Define them using Tools > Script editor.
Watch out for name restrictions; I was confused by the behavior of functions that I created with names like "function x10() {}" not being found. Renaming to a longer name fixed it. There are probably documented rules for what isn't allowed, but I don't know where they are.
129
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
