Google Sheets Quartile Function Giving Error

Question

In Google sheets I write the formula =QUARTILE(G7:G27, 1) to give the lower quartile between G7 and G27 but it gives me #ERROR!

Here is a print screen that shows my problem.

Answer 1

use ; as fx argument separator:

=QUARTILE(G7:G27; 1) 

see (not): https://stackoverflow.com/questions/73767719/locale-differences-in-google-sheets-documentation-missing-pages