# Re: Excel formula not able to work this out

joeu2004
Guest
Posts: n/a

 28th Jul 2012
"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.

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post =?Utf-8?B?Uy4gR29uemFsZXo=?= Microsoft Outlook Discussion 0 13th Jul 2007 02:16 AM =?Utf-8?B?YmJhcmttYW4=?= Windows XP Print / Fax 9 29th Mar 2006 09:32 PM sony Microsoft Windows 2000 Active Directory 6 4th Jun 2004 03:48 PM =?Utf-8?B?SHVnaCBNb3J0ZW5zZW4=?= Windows XP Networking 1 16th Feb 2004 11:29 AM psarang Microsoft Windows 2000 Applications 0 17th Sep 2003 12:15 AM

Features