View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
FoulDwimmerlaik FoulDwimmerlaik is offline
external usenet poster
 
Posts: 7
Default trouble getting a formula to repeat rows

Thanks in advance to all your help.
I have a formula I'm using, =(C1*3)+(E1*5)+(F1*3)+(I1*5)+K1, and I need it
to repeat at the end of every row and recalculate every row, so that every
row has its own total. Trouble is, when I copy the formula from the Formula
bar and paste it into the last cell of the next row, it just keeps
calculating for the very first row. I've checked my settings and I'm set to
"automatic" calculation not manual (as I've read that is a common problem)
but to no avail. Please help me!
Also, on a probably much simpler note: several columns of data are less than
whole numbers, ie., .345, .245, etc. How can I change these to represent
whole numbers, ie., 345 and 245 sans decimals?
Thanks again!