prinz reyes wrote:thanks for the reply..i have found the solution..
instead of using ; i used comma(,) in the formula.
so instead of IF(C53=0; 0; C52/C53*100) it should be this way IF(C53=0, 0, C52/C53*100) .
i don't know how it happened but it worked!
thanks for your response!i really appreciate!
I stumbled across the same problem: using , instead of ; worked, but i don't know why...
Now it gives me an error on the ^ symbol. Maybe is there another character to use instead of ^ ??
I have searched around if there is a syntax guide, but I haven't found anything =(