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!