Package org.boris.expr.function.excel

Examples of org.boris.expr.function.excel.SUMIF


    public void testSUM() throws Exception {
        assertResult("sum(34,45)", 79.);
    }

    public void testSUMIF() throws Exception {
        AbstractFunction s = new SUMIF();
        assertEquals(eval(s, toArray(1, 2, 3), ">2"), 3.);
        assertEquals(eval(s, toArray(1.658, 1.656, 1.657), "<1.657"), 1.656);
        assertEquals(eval(s, toArray(1, 2, 3), "<=2"), 3.);
        assertEquals(eval(s, toArray(1, 2, 3), ">=2"), 5.);
        assertEquals(eval(s, toArray("apples", 2, 3), "apples", toArray(4.5)),
View Full Code Here

TOP

Related Classes of org.boris.expr.function.excel.SUMIF

Copyright © 2018 www.massapicom. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.