Package org.boris.expr.function.excel

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

29
30
31
32
33
34
35
36
37
38
39
        assertException("false(1)");
        assertEquals(eval(f), false);
    }

    public void testIF() throws Exception {
        IF i = new IF();
        assertResult("if(10<100,4,5)", 4);
        assertEquals(eval(i, parse("10.1>=11"), "right", "wrong"), "wrong");
        assertResult("IF(3>=1,\"*\",IF(4<>1,\"first\",\"second\"))", "*");
        assertResult("IF((A1+A2)<=3,\"yes\",\"no\")", "yes");
        assertResult("IF(A1<A2,B1,B2)", null);
View Full Code Here
TOP

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

  • org.boris.expr.ExcelLogicalFunctionsTest
  • org.boris.expr.Expr
  • org.boris.expr.ExprException
    • 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.