For a more descriptive request, ask:
> Create an Excel formula
for cell D2 that multiplies units sold in B2 by unit price in C2. Return a blank
if either cell is empty.
A likely answer is:
“`excel
=IF(OR(
B2=””,C2=””),””,B2
;)
Google Sheets uses many functions that resemble Excel functions, but there are differences
in syntax, array behavior, and available features. Tell ChatGPT that the formula
is for Google Sheets rather than Excel.
For example, to combine a first name in column A and a last name in column B, use:
gs
=TRIM(A2&” “&B2)
To apply the result to an entire column
in Google Sheets, an array formula may be appropriate: gs
=ARRAYFORMULA(
IF(A2:A=””,””,TRIM(A2:A&” “&B2:B)))
A useful prompt would be:
In Google Sheets, create an array formula that combines first and last names from columns A and B, leaves empty rows blank, and removes extra spaces.ChatGPT can also help with
QUERY, a Google Sheets function that resembles
a simplified database query. For example, a request to total sales by department
might produce:
“`gs
=QUERY(A1:C,”select A, sum(C) where A is not null group by A label sum(C) ‘
Total Sales'”,1)
```
=PROPER(TRIM(A2))