public static object MOD(object _x, object _y) { var x = OPs.xl2dbl(_x); var y = OPs.xl2dbl(_y); var d = Math.Truncate(x / y); return(x - d * y); }
public static object DAY(object date) { if (W.Common.Utils.IsEmpty(date)) { return(DBNull.Value); } return(OPs.FromExcelDate(OPs.xl2dbl(date)).Day); }
public static object Divide(object arg) { return(Utils.Calc(arg, 2, 1, data => { var r = OPs.xl2dbl(data[0]) / OPs.xl2dbl(data[1]); if (double.IsNaN(r)) { return null; } else { return OPs.WithTime(data[0], data[1], r); } })); }
public static object LOG(object x, object y) { return(Math.Log(OPs.xl2dbl(x), OPs.xl2dbl(y))); }
public static object ROUND(object x, object nDigits) { return(Math.Round(OPs.xl2dbl(x), Convert.ToInt32(nDigits))); }
public static object POWER(object x, object y) { return(Math.Pow(OPs.xl2dbl(x), OPs.xl2dbl(y))); }
public static object SQRT(object x) { return(Math.Sqrt(OPs.xl2dbl(x))); }
public static object LN(object x) { return(Math.Log(OPs.xl2dbl(x))); }
public static object EXP(object x) { return(Math.Exp(OPs.xl2dbl(x))); }
public static object ATAN2(object x, object y) { return(Math.Atan2(OPs.xl2dbl(x), OPs.xl2dbl(y))); }
public static object ATAN(object x) { return(Math.Atan(OPs.xl2dbl(x))); }
public static object COS(object x) { return(Math.Cos(OPs.xl2dbl(x))); }
public static object SIN(object x) { return(Math.Sin(OPs.xl2dbl(x))); }
public static object INT(object x) { return(Math.Floor(OPs.xl2dbl(x))); }
public static object ABS(object x) { return(Math.Abs(OPs.xl2dbl(x))); }