A B 7.5 8 8.2 8 9.5 10 3.7 4 7.4 7 7.7 8 Total 44 45 Please refer above example I have some figures in column "A" it shold be rounded off , done in column "B" what I want is aftrer rounding off
toal increase by 1. that is before round off total 44 ,after rounding off total 45. is there any way to round off without affecting total. total sld remain unchanged