"barry duncan" <(E-Mail Removed)> wrote:
> I have a bar length of metal say 6000 in 1 cell and the £55.12
> value in another how can i change the size of the bar length
> so that the value changes automatically. Probably straight
> forward but brain is not that advanced yet.
I presume you are asking: how can you determine the price based on the
length purchased?
If 6000 is in A1, 55.12 is in B1, and the length purchased is in A2, the
price can be computed as follows (perhaps in B2):
=ROUND(A2*$B$1/$A$1,2)
Note that B1/A1 is the price per inch.
Also note that use of $B$1 and $A$1 ("absolute references") allow you to
copy the formula down the column, assuming other purchase lengths are in
column A.
|
Similar Threads
