Easy Pricing

Excel Help for Easy Pricing in Automating Data Analysis Tasks

Forum Topic

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

Find relevant Excel templates and add-ins for Easy Pricing in the Excel Business Solutions Directory