Excel formula not able to work this out

[barry duncan]

I have a bar length of metal say 6000 in 1 cell and the £55.12 value i
another how can i change the size of the bar length so that the valu
changes automatically. Probably straight forward but brain is not tha
advanced yet.

Thanks
Barr

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[Spencer101]

I have a bar length of metal say 6000 in 1 cell and the £55.12 value i
another how can i change the size of the bar length so that the valu
changes automatically. Probably straight forward but brain is not tha
advanced yet.

Thanks
Barry

Hi Barry,

Have a look at the attached.
From the limited info in your original post, I presume there is
standard "cost per length" which is just the cost your gave divided b
the bar length.

The attachment should make sense but let me know if I've got the wron
end of the stick

+-------------------------------------------------------------------
|Filename: Barry Duncan Example.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=509
+-------------------------------------------------------------------

 

[joeu2004]

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.

 

[Spencer101]

joeu2004
many thanks

given that i probably didnt explain this properly your explanation wa
exactly what i wanted to acheive.

thanks again
barry

No thanks for me then...? *sob sob*
Despite my answer being first and practically the same as joeu2004's...

Good job I'm not easily offended eh? ;

+-------------------------------------------------------------------
+-------------------------------------------------------------------