| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro to repeat a formula a set number of rows apart | Excel Discussion (Misc queries) | |||
| macro to repeat a formula a set number of rows apart | Excel Discussion (Misc queries) | |||
| repeat a formula same column same number of rows apart | Excel Discussion (Misc queries) | |||
| repeat a formula same column same number of rows apart | Excel Discussion (Misc queries) | |||
| Title Cut Off if Rows to Repeat & Columns to Repeat are Both Selec | Excel Discussion (Misc queries) | |||
Threaded Mode
