98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Functions
Functions
Resolved · Urgent Priority · Version 2003
Nikky has attended:
No courses
Functions
I have a row with constant cell figures of
RE: Functions
Hi Nikky,
In new column E, make the cell:
=($A$1*A2)+($B$1*B2)+($C$1*C2)+($D$1*D2)
Then use 'fill down' to copy the formula down to the other rows in the E column.
The dollar signs ($) before the letter and number cell reference indicates the formula should keep the same cell reference each time the formula is copied to another cell. It's called absolute cell referencing.
See also the attached spreadsheet in Excel 2003 format.
Regards, Rich
Attached files...
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Add a € to your cellsIf you need to add a € symbol to your Excel sheet - hold down the key Alt Gr and 4. |