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
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
