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.

CodePudding user response：

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)

CodePudding user response：

use ; as fx argument separator:

=QUARTILE(G7:G27; 1) 

see (not):