| Home > Forum Home > Automating Data Analysis Tasks > Easy Pricing > Easy Pricing | Share |
Easy Pricing
Excel Help for Easy Pricing in Automating Data Analysis Tasks
| Forum Topic | Login |
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 | ||
| View Full Post |
| Find relevant Excel templates and add-ins for Easy Pricing in the Excel Business Solutions Directory |