Google Sheets Quartile Function Giving Error

309 views Asked by At

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.

enter image description here

2

There are 2 answers

0
player0 On BEST ANSWER
0
doubleunary On

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)