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

Answer 2

In the event your spreadsheet locale uses commas , as decimal separators, you will have to use semicolons ; as formula argument separators, like this:

=quartile(G7:G27; 1)