How to subtract two columns in Google Sheets query?

Question

I checked the documentation but couldn't find a way to subtract two columns from each other.

Imagine you have two columns and you want to construct a query that return the subtraction of those two columns.

See aritmethic operators
– Rubén - Volunteer Moderator - ♦
Commented Oct 26, 2017 at 15:58 — Rubén - Volunteer Moderator -, Commented Oct 26, 2017 at 15:58

pnuts · Accepted Answer · 2017-11-12 14:30:18Z

1

For example with a formula such as:

=query(A:B,"select A-B label A-B 'Profit'")

answered Nov 12, 2017 at 14:30

pnuts

17.7k5 gold badges54 silver badges103 bronze badges

Add a comment |

1 Answer 1