Featured Image- Dominik Scythe

Google Sheets – Query And Other Functions

Photo by Dominik Scythe on Unsplash Google Sheets – Query & Other Functions IF & IFS Functions June 15, 2019 https://youtu.be/hG5vKMb0Lpo IF(logical_expression, value_if_true, value_if_false) Example: IF(A2 = “foo”, “A2 is foo”, “A2 is not foo”) IFS(condition1, value1, [condition2, …], [value2, …])Example: IFS(A1>90, “A”, A1>80, “B”)   Combine Cell Contents June 15, 2019 https://youtu.be/Sg6XTFztZdo =B2&” “&C2 JOIN(delimiter, value_or_array1, [value_or_array2, …]) =TRIM(JOIN(” “,B12:C12,E12, D12)) Mr. Robert B Haight  TRIM: to eliminate the …

Google Sheets – Query And Other Functions Read More »