Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying and pasting excel formulae
I have a worksheet of cash figures that I need t o show a 3%, $% & 5%
increase. I devised a formula =Sum(C1)*B2/100+B2 which i then wanted to copy and paste down. But how can i copy and paste the formula so that (C1 remains constant whilst the B numbers increase chronologically. please help URGENT |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying and pasting excel formulae
hi,
use absolute reference at C1. $C$1 with out the dollar signs are reletive references and will change reletive tn where you paste. regards FSt1 "bennyrub" wrote: I have a worksheet of cash figures that I need t o show a 3%, $% & 5% increase. I devised a formula =Sum(C1)*B2/100+B2 which i then wanted to copy and paste down. But how can i copy and paste the formula so that (C1 remains constant whilst the B numbers increase chronologically. please help URGENT |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying and pasting excel formulae
Thanks a lot
FSt1 wrote: hi, use absolute reference at C1. $C$1 with out the dollar signs are reletive references and will change reletive tn where you paste. regards FSt1 I have a worksheet of cash figures that I need t o show a 3%, $% & 5% increase. I devised a formula =Sum(C1)*B2/100+B2 which i then wanted to copy and paste down. But how can i copy and paste the formula so that (C1 remains constant whilst the B numbers increase chronologically. please help URGENT |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying from Excel - pasting in Publisher | Excel Discussion (Misc queries) | |||
Copying from Excel - pasting in Publisher | Excel Worksheet Functions | |||
Copying from Excel - pasting in Publisher | Excel Discussion (Misc queries) | |||
Excel 2000 problem copying drawingobjects between sheets | Excel Discussion (Misc queries) | |||
How to remove an extra line added by excel when pasting into notep | Excel Discussion (Misc queries) |