sopedro

Hi,

Any news about this??
I have the same issue, my formulas stop working suddenly and some of them shows “invalid formula” in the output box. Please help me in this issue.

Thanks,

pedro

Thanks Igor…

One more thing, how can i control the visibility of an element with a condition?

Thank you

sorry, i found the solution, the problem is the construction of the nested “if” conditions i made.

The correct one is:

IF(actividade=1, result_tmb*1.2, IF(actividade=2, result_tmb*1.375, IF(actividade=3, result_tmb*1.55, IF(actividade=4, result_tmb*1.725, IF(actividade=5, result_tmb*1.9)))))

??

Hi jazzigor, Your plugin is very cool and usefull.

But, i have a litle issue here, i have a formula with 5 nested ‘if’ conditions, but the formula only calculate de first two conditions. Why?

The conditions are dependent os an output formula and a dropdown list

the formula:

IF(actividade=1, result_tmb*1.2, IF(actividade=2, result_tmb*1.375), IF(actividade=3, result_tmb*1.55), IF(actividade=4, result_tmb*1.725), IF(actividade=5, result_tmb*1.9))

Thank you,

Pedro