Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Want to make formula automatically figure out cell number in the r
example (this would be in column f)
=SUM(c1*1230+(d1*234)+(e2*567) ok for each row I am having to input each cell number. Is there a way to make it so that the formula in column f would know to use the numbers in C,D,E to do the formula in column F Row X |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Want to make formula automatically figure out cell number in the r
Hi Dave
you don't need the SUM( ) just =(c1*1230)+(d1*234)+(e2*567) will suffice. Strictly speaking, you don't need any of the parentheses, as multiplication takes precedence over addition in the formula, but it often helps, so you can see clearly what you have written. As you copy the formula down through column F, the row number will automatically increase to become =(c2*1230)+(d2*234)+(e3*567) etc. -- Regards Roger Govier "Daveb716" wrote in message ... example (this would be in column f) =SUM(c1*1230+(d1*234)+(e2*567) ok for each row I am having to input each cell number. Is there a way to make it so that the formula in column f would know to use the numbers in C,D,E to do the formula in column F Row X |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make a formula automatically detect changes in values | Excel Worksheet Functions | |||
Stumped: If a cell contains a formula, can you make text color automatically change? | Excel Worksheet Functions | |||
Can I make the number in one cell automatically appear elsewhere? | Excel Worksheet Functions | |||
How to make Cells automatically become 'highlighted' when number . | Excel Worksheet Functions | |||
How to make Cells automatically become 'highlighted' when number . | Excel Worksheet Functions |