Custom Formula Examples for Data Exports

Below are some examples of formulas or functions that you can use What to use =SUM(range) What it does it will add the values of a cell to another cell Example =SUM(A:A+B:B+C:C) How it can be used You can use the sum to add for example two custom costs in columns A and B with the selling price in column C. What to use =CONCATENATE(Value1, “ ”,Value2) What it does allows you to combine values of multiple cells into one cell, e.g., first and last name Example =CONCATENATE(A:A&","&B:B) How it can be used You can use the concatenate to join the brand name with a comma followed by the manufacturer name. What to use =IF (logical_test, [value_if_true], [value_if_false]) What it does allows you to run a logical test and returns one value for a TRUE result, and another for a FALSE result. Example =IF(B:B