0

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

Mayukh Bhattacharya
  • 12,541
  • 5
  • 21
  • 32
pedroleitao1999
  • 31
  • 4

2 Answers2

1

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)
doubleunary
  • 13,842
  • 3
  • 18
  • 51
0

use ; as fx argument separator:

=QUARTILE(G7:G27; 1)

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

enter image description here

player0
  • 124,011
  • 12
  • 67
  • 124