98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel course london - Formulas
microsoft excel course london - Formulas
Resolved · Low Priority · Version Standard
Sun 13 Jan 2008, 20:56Delegate Stephen said...
Stephen has attended:
Project Intro Intermediate course
Dreamweaver 8 Introduction course
Dreamweaver 8 Intermediate course
Formulas
I need a formula to multiply a cell, say A1 x a value say 5 x another Cell, say A8 ( which contains a rate, which may change ), But I need to copy over many rows.
Eg: 0.10 ( Cell A1 ) x 5 x 1.25 ( Cell A8 ) this formula is to be entered in cells say C2 but copied in C3,C4,C5 etc etc.
Ref: A1 will be Kgs, 5 = bar length, A8 = Rate per Kg
I hope this explains ok.
Thanks
Wed 16 Jan 2008, 13:47Trainer Rajeev said...
RE: Formulas
Dear Stephen
I think I need a bit more clarification with regards to the question you have asked.
I would like to repeat what you have said you have a value 0.1 (KG) in cell A1 and value 1.25 (Rate per KG) in cell A8.
You are entering a formula in cell C2 which will be =A1*5*A8
You want to copy the resulting cell C2 to C3, C4 and so on.
First of all I would like to know if there will be any values in cell A2: A7
Assuming that there are values in the cell range A2:A7 I guess that you want to copy the results to C2:C8 where the values will come from A2:A7. I am also guessing that you want the cell A8 to be fixed so that all the cells (A2:A7) are multiplied by Cell A8.
If I am predicting your question right then you
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:Hide data in Excel WorksheetsLet's say you have some data in cell 'C5' you would like to hide from the casual viewer. |
