Skip to content

Nested Formular Error with CalCellValue #1164

@ffleader1

Description

@ffleader1

Description
Cannot use nested function with calculate cell value. It produces incorrect result.

Try this function: =IF((ROUNDUP(IF(A1=16,(A2*2+4*0.3+1+1),IF(A1=4,(A2+2*0.3+1+1),(A3*SQRT(A1/2)+(SQRT(A1/2)*0.3)+1+1))),0))<=A4,(ROUNDUP(IF(A1=16,(A2*2+4*0.3+1+1),IF(A1=4,(A2+2*0.3+1+1),(A3*SQRT(A1/2)+(SQRT(A1/2)*0.3)+1+1))),0)),-1)

It works in excel but will not work with the plugin. It gives this error: IF accepts at most 3 arguments

Excelize version:

v2.5.0

Metadata

Metadata

Assignees

No one assigned

    Labels

    confirmedThis issue can be reproduced

    Type

    No type

    Projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions