You can copy the formula in the top formula cell down by dragging its bottom
right-hand corner (ie the fill handle - looks like a black square when you
point the cursor to it)

Place in B2: =C2/11
Drag B2 down

Btw, I'm not sure if the formula in B2 should be: =C2/10, going by the
returns that you expect (as you describe in your post)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,000 Files:359 Subscribers:56
xdemechanik
---
"Theo" wrote:
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)?