decimal problem

Originally Posted by radhkrishna

suppose I take the values for B1, B2 ,B3 as 24.68,25.40,24.76.
B1+B2+B3 gives us 74.84 .

assign the rounoff values of b1,b2,b3 to c1,c2,c3 then when we add c1+c2+c3=25+25+25=75 we get 75

instead of that it is showing 74.84 .

what is the solution for getting the value 75.please tell

Try this ...

=round(sum(B1:B3),0)


Hope this helps.