Die deutsche Fassung finden Sie hier.
In cobby you can of course use all formulas excel does offer, this article just covers the most natural ones and all formulas that cobby itself brings to the table.
VLOOKUP - to find things in a table or a range by row. For usage help check microsoft excel course videos (Deutsche Fassung)
INDEX(MATCH) - Like VLOOKUP but has a slightly different use-case.
TRIM - Removes leading and trailing spaces, see Remove unnecessary spaces from all SKUs for an example.
CONCATENATE - Joins two or more text strings into one string.
NOT - Logic function to make sure one value is not equal to another.
IF - The basis for most logical comparisons between values and expectations. Use to check if a condition is true.
IFS - Like IF but for up to 127 conditions without the need to nest formulas.
COUNTIF - To count the number of cells that meet a criterion.
COUNTA - Counts the number of cells that are not empty in a range.
AND - to determine if all conditions in a test are TRUE.
RANDBETWEEN - Returns a random integer number between the numbers you specify.
ROUND - Rounds a number to a specified number of digits.
VALUE - Converts a text string that represents a number to a number.
TEXT - lets you change the way a number appears by applying formatting to it
ISERROR - Checks to see if an error condition exists.
IFERROR - Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula.
TODAY - Returns the serial number of the current date.
LEFT - returns the first character or characters in a text string, based on the number of characters you specify
RIGHT - returns the last character or characters in a text string, based on the number of characters you specify.
MID - returns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify.
LEN - returns the number of characters in a text string.
FIND - locate one text string within a second text string, and return the number of the starting position of the first text string from the first character of the second text string.
MIN - Returns the smallest number in a set of values
MAX - Returns the largest value in a set of values.
SUBSTITUTE - to replace specific text in a text string.
have a look at the Excel function-Wizard
, cobby has its own category of functions there:
cobby formulas - Images
IMAGE.CREATE Formula to put a new single image into the shop, including all possible parameters
IMAGE.GETFILE Used to fetch the name of an image from the Images-column
IMAGE.GETLABEL Used to fetch the description of a single image from Images-column
IMAGE.GETURL Used to fetch the URL from a single picture in the Images-column
IMAGES.ADD Formula to add images to a product for that images already exist
IMAGES.CREATE Formula to bring multiple images into the shop
IMAGES.GETFILES Used to fetch the names of multiple images from the Images-column
IMAGES.GETLABELS Used to fetch the description of multiple images from the Images-column
IMAGES.GETURLS Used to fetch the URLs from a multiple pictures in the Images-column
IMAGES.REPLACEFILENAMES Formula to replace the filenames of images in the shop
IMAGES.REPLACELABELS Formula to replace the descriptions of images in the shop
cobby formulas - General
ONETIMEFORMULA Formula that runs only once and removes itself after saving in cobby
WENNISTLEER (IfIsEmpty) Checks if a cell is empty and then executes