Solved
Need help with Microsoft Excel 2007 formula
Posted on 2014-01-30
I have an Excel database with a single column showing different product cost and I want to add markup to each product cost based on that product cost.
For instance if the cost of the product is less than $10 then markup is 25%, but if cost is >$10 but < than $20 markup is 22%, if cost is >$20 but <$30 then markup is 20%, etc. And the result of the calculation put in a seperate column.
Was considering using the =LOOKUP but not sure of the formula:
Here's what I came up with but Excel doesn't like it. (A1 is one cell with the actual Cost).
=LOOKUP(A1,{10,20,30},{A1*.25+A1,A1*.22+A1, A1*.20+A1})
I'm new at Excel and would appreciate any help! Thanks