how do i set up a rule for excel to do the following. i want column b to be c
divided by 11. but i want it to calculate for each row. example c2 reads 110
so it will automatically show 11 in b2. in c4 the number is 990 so b4 should
read 99. is there anyway i can create a rule or something along those lines
or in each line do i need to type in say b2 (=c2/11) and in b4 (=c4/11)?