Auto-Calculate price based on width x height

Guybrush

New Member

Join Date: Jul 2011

Posts: 1

6th Jul 2011

G'Day! I'm trying to create a excel sheet which will automatically calculate a price based on a given width or height. At the moment we calculate price by manually looking in a price book which has plenty of rows and columns and prices. I want to simplify this by simply entering the dimensions so it automatically calculates price based on the dimensions entered.

E.G.
you enter width of 1500mm in one field, then 900mm in another field, and next to that it automatically shows the price (based on some price list on another spreadsheet or workbook).

Any Help or Advice?
Cheers Mates!

« Re: Error populating a list box | UDF for Aging in excel - Help needed »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

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 Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calculate the height of a Label control given a fixed width	Gary	Microsoft Dot NET Compact Framework	2	26th Jun 2006 02:48 AM
auto fit column width and row height	=?Utf-8?B?a2I=?=	Microsoft Excel Misc	0	22nd May 2006 07:54 PM
Creating form, need to set width but auto size height on text box	=?Utf-8?B?bWF0dGhlbG0x?=	Microsoft Word Document Management	3	10th May 2006 12:14 AM
calculate/convert volume price to monthly average price	=?Utf-8?B?QnVsdGdyZW4=?=	Microsoft Excel Worksheet Functions	2	14th Feb 2006 09:36 AM
auto column width/row height?	=?iso-8859-1?Q?Eep=B2?=	Microsoft Excel Discussion	0	25th Jun 2004 02:42 AM