For example, an argument that should be a range of cells: “B3:B14.” This is an example input for this argument.For example, “A single value you’re searching for.” This is a short description of what the function expects for this argument.For every argument placeholder you define, these fields are available: When you include defined arguments, the function expects inputs for each argument when inserting the function into a cell.Īfter you set up the primary components above, you can add more details on the second page. It’s the written formula that you insert into a cell.For example, if you give your placeholder a name like "A1” or “AA11," you get an error.Can’t be the same name as another argument placeholder in the named function.For example, argument names “ CELL'' or “ RANGE” are for when the input you expect is a single cell, or a range of cells, respectively. Placeholders are descriptions of the type of inputs the function expects.The description of the function that appears in the "About" section of the function help box.Must have no special characters except for underscores.For example, if you give your function a name like "A1” or “AA11," you get an error.Can’t be in either "A1" or "R1C1" syntax.Can’t be named the same as a built-in Sheets function like SUM.The name of the function you use to insert the function into a cell.The 4 primary components in a named function include: With named functions, you can create custom functions with an intuitive interface without writing any code. If you want to take in various inputs to your function, when you write a named function, you must define argument placeholders.īefore, you could only create custom functions with App Script, which requires you to write Javascript. These arguments are placeholders and descriptions of the type of inputs the function expects. If you insert the text “ logical_expression”, “ value_if_true” or “ value_if_false" as arguments into a cell, you get an error. IF(logical_expression, value_if_true, value_if_false) When you create a named function, use text as placeholders for inputs.įor example, the IF function, takes in a maximum of 3 arguments:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |