Easy Pricing

Excel Help for Easy Pricing in Automating Data Analysis Tasks

Easy Pricing

Rate this: (3/5 from 1 vote)

	Hi Folks, would appreciate any help or advise here. I have a spreadsheet that contains hundreds of references, and prices against each of these reference number for framing products offered. for example: Reference Number Price (£) PW940527-1616 £81.40 PW940527-1815 £83.03 each frame that I offer to my customers have three major parts. The wooden outer, the mount board and the print. Each have a unique reference number. What I would like to be able to do is to type the reference number the customer would like, and in the next cell, the price is returned for each of the component parts. then I can total the costs up. Just now I use the search function to scroll through the tables, and write down each of the three prices by hand. I'd like to automate this if possible. Thanks in advance for the help.
	Posted by ceesd2 on 23 Apr 2009

Replies - Displaying 1 to 1 of 1

Order Replies By: Most recent | Chronological | Highest Rated

	Easy Pricing Rate this: (3/5 from 1 vote) Hi, use this formula to get the required price IF(C5="PW940527-1616",81.4,IF(C5="PW940527-1815",83.03,IF(C5="PW940527-1850",50,"na"))) in next cell put the no of frames sold in next cell multiply 1st and 2nd cell to get the out put Ex say in c5 you insert the reference no and in c6 put the first formula and in c7 put the no of unit sold and in c8 put =c6*c7 Have a great day! Regards, Vimal
	vimal
	Posted by vkumarv1982 on 29 Apr 2009

Displaying page 1 of 1