Partager via

WorksheetFunction.Quartile_Exc(Object, Double) Méthode

  • Référence

Définition

Espace de noms:
Microsoft.Office.Interop.Excel
Assembly:
Microsoft.Office.Interop.Excel.dll

Renvoie le quartile de l’ensemble de données d’après des valeurs de centile comprises entre 0 et 1, exclus.

public:
 double Quartile_Exc(System::Object ^ Arg1, double Arg2);
public double Quartile_Exc (object Arg1, double Arg2);
Public Function Quartile_Exc (Arg1 As Object, Arg2 As Double) As Double

Paramètres

Arg1
Object

Array : tableau ou plage de cellules de valeurs numériques pour lesquelles vous souhaitez obtenir la valeur de quartile.

Arg2
Double

Quart : valeur à renvoyer.

Retours

Double

Remarques

Si le tableau est vide, Quartile_Exc retourne le #NUM ! Autrement, la méthode INDEX renvoie la valeur d'erreur #REF!.

Si le quartile n’est pas un entier, il est tronqué.

Si quart ≤ 0 ou si quart ≥ 4, Quartile_Exc renvoie le #NUM ! Autrement, la méthode INDEX renvoie la valeur d'erreur #REF!.

Min(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object), Median(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object)et Max(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object) retournent la même valeur que Quartile_Exc lorsque quart est égal à 0 (zéro), 2 et 4, respectivement.

S’applique à