How to round off in a QUERY?

Question

Google Sheets

Good afternoon!
I work with Google Spreadsheet. The example is for educational purposes only.
I am doing a QUERY query in which I get a numeric value, after which I want to display an additional column with a rounded value.
=QUERY(A:C;"select A, '"& ОКРУГЛ(&"'A'"&;1)&"'")
The desired result could not be achieved, the error "Syntax error" falls. I would be glad to help :)
Thanks for reading the question!

Answer 1

Google Query Language does not support the rounding directive.

You can use rounding formatting which solves the display issue

=QUERY({A2:A6,A2:C6},"select Col1, Col2 format Col1'', Col2'#.00'")

or preliminary rounding, which may introduce some inaccuracies in the resulting data

=QUERY({A2:A6,ARRAYFORMULA(ROUND(A2:A6,2))},"select Col1, Col2")

Spreadsheet example https://docs.google.com/spreadsheets/d/1NfP4x3S_EU...