formula correction

[p adhikari]

what formula to be put in one cell column

=sum(c1+d1)*10/100

how will u find round the value in same column with modifying above formula

kindly help

 

[Hui]

P adhikari


Do you mean =Round((C1+D1)/10),0)


There is no need to use Sum to add two number

=Sum(C1+D1)

is the same as

=C1+D1


Also *10/100 is the same as /10

so unless the two number are going to change always simplify equations, they calculate faster