morning, Problem: column A1 = 10 ( Square meters ) B1= 117,30 (cost of item ), C = Formula ( A1/ 20) how many Square meters a product will last. C= .5 I then convert C to a number value = 1 and not a fraction to get whole numbers. But when I calculate value of C mulitplied by B1 Excel calculates the following : .5 x 117.30 and not the value 1 x 117.30, please assit
Solved by Z. D. in 25 mins