![]() ![]() You if you dont choose a delimiter, it concatenates the data without one. You specify one delimiter, at the beginning of the arguments, and then the function uses that same delimiter between each entry. It should be easy to take columns containing names, addresses, and phone numbers and combine them into a single column that collects all the data for each row, right But it hasnt been, until now. You can optionally specify a default value to be returned if there is no match. It evaluates an expression against a list of values and returns the result that corresponds to the fist matching value. These return the maximum and minimum values, respectively, from the data range. It helps create complex sets of logical conditions, as an easier alternative to super-long formulas with multiple levels of nested IF functions. Something that should be pretty simple, like assigning grades of A, B, C, D, or F according to numeric scores, required a ton of typing.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |