You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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
The text was updated successfully, but these errors were encountered:
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:
The text was updated successfully, but these errors were encountered: