Calculate formula base of list menu

rkeles · #1 09-20-2010, 03:41 AM

Hi,
I would like to make a quotation form in excel with separate rates for different items. I will explain how it will work and I wish you help me to do it.

Quotations for;
· Lambiri
· Doors
· Partitions
As you see on picture rates are different. For lambiri 20,000.00, for doors 40,000.00 for partition 70,000.00
In the Column G rate has been calculated manually. In G6 this formula works =D6*A3
In G7, =D7*B3
But for easy way I would like to formula different way to make it quick and be more professional.
In the Column E (ITEM) ; there is list menu “Lambiri – Door – Partition”
And as you see on top left corner what the RATES are.
Now my question is:
If I select an item from list menu, rate will be what ever in RATES shows.
For example;
If I select item from list menu “Partition” it will calculate result in to G8, C3*D8
Or if select item “Door” in same cell, it will calculate result in to cell, B3*D8
I wish you can help me to resolve this…

Thank you…

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can't calculate formulas	Cpat	Excel	2	06-09-2010 02:07 PM
How do I set up the fields in mail merge word 07 from my data base	mbcrabber	Mail Merge	4	06-06-2010 01:25 PM
Need help creating a data base for mail merge.	acedking90	Mail Merge	0	07-27-2009 11:04 AM
Calendar Base	prayojana	Project	0	11-12-2007 01:13 AM
How to get cells to calculate time?	jrasche2003@yahoo.com	Excel	2	02-09-2007 07:10 AM