I want to make a column that summarizes 3 other columns
- My 3 columns are composed of IF formula that gives a number based on a product name in N-1column.
- If your data is in text format:
- If your data are numeric values??:
- The FIXED function converts numeric values ??to a string, the 0 indicates the number of decimal places.
- Even simpler: use the =CONCATENER(A1;B1;C1) function
Thanks to pepe
for this tip.