示例#1
0
// Mod returns the remainder after number is divided by divisor. The result has the same sign as divisor.
func Mod(number, divisor float64) (float64, errs.ErrorType) {
	// Error
	err := errs.ErrorType{}
	if math.IsNaN(divisor) || math.IsNaN(number) {
		err.Type = errs.ErrorCode(6) // #NUM!
		err.Formula = "Mod"
		err.Error = "Occurs if any of the supplied arguments are non-numeric."
		return 0.0, err
	}

	if divisor == 0 {
		err.Type = errs.ErrorCode(2) // #DIV/0!
		err.Formula = "Mod"
		err.Error = "Occurs if the supplied denominator argument is zero"
		return 0.0, err
	}

	sign := Sign(divisor)

	n, err := Abs(number)
	if err != (errs.ErrorType{}) {
		return 0.0, err
	}

	d, err := Abs(divisor)
	if err != (errs.ErrorType{}) {
		return 0.0, err
	}

	return sign * (n - (d)*float64(int((n)/(d)))), err
}
示例#2
0
// Abs function returns the absolute value of a number.
// The absolute value of a number is the number without its sign.
func Abs(number float64) (float64, errs.ErrorType) {
	// Error
	err := errs.ErrorType{}
	// Validate Number
	if math.IsNaN(number) {
		// If you get an error from the Excel Abs function, this is likely to be the #VALUE! error
		err.Type = errs.ErrorCode(3)
		err.Formula = "Abs"
		err.Error = "Occurs if the supplied number argument cannot be recognised as numeric value"
		return 0.0, err
	}

	return abs(number), err
}