Class NormSInv

  • All Implemented Interfaces:
    FreeRefFunction, Function, Function1Arg

    public final class NormSInv
    extends Fixed1ArgFunction
    implements FreeRefFunction
    Implementation for Excel NORMSINV() and NORM.S.INV() functions.
    • https://support.microsoft.com/en-us/office/normsinv-function-8d1bce66-8e4d-4f3b-967c-30eed61f019d
    • https://support.microsoft.com/en-us/office/norm-s-inv-function-d6d556b4-ab7f-49cd-b526-5a20918452b1
    • Field Detail

      • instance

        public static final NormSInv 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).