Class NormSDist

  • All Implemented Interfaces:
    FreeRefFunction, Function, Function1Arg

    public final class NormSDist
    extends Fixed1ArgFunction
    implements FreeRefFunction
    Implementation for Excel NORMSDIST() and NORM.S.DIST functions.
    • https://support.microsoft.com/en-us/office/normsdist-function-463369ea-0345-445d-802a-4ff0d6ce7cac
    • https://support.microsoft.com/en-us/office/norm-s-dist-function-1e787282-3832-4520-a9ae-bd2a8d99ba88
    • Field Detail

      • instance

        public static final NormSDist instance
    • Method Detail

      • evaluate

        public ValueEval evaluate​(ValueEval[] args,
                                  OperationEvaluationContext ec)
        Specified by:
        evaluate in interface FreeRefFunction
        Parameters:
        args - the pre-evaluated arguments for this function. args is never null, nor are any of its elements.
        ec - primarily used to identify the source cell containing the formula being evaluated. may also be used to dynamically create reference evals.
        Returns:
        never null. Possibly an instance of ErrorEval in the case of a specified Excel error (Exceptions are never thrown to represent Excel errors).