Multiply cell by varying percent based on cell value.

[lesmcqueen73]

I've tried to find an answer here but I actually don't know the correct name (if there is one) for this formulation.

What I'd like to do is multiply a cell by say 10% but only if the cell is equal/less than $100.... or... multiply by 5% if the cell is greater than $100.

I have a range of products with their corresponding prices that need to have a mark-up set for each, so if product A is $100 then multiply by 10%... or if product A is greater than $100 then multiply by 5%.

The end result would be for example.

Product A $100 $110
Product B $50 $55
Product C $99 $108
Product D $150 $157

Thanks for any help here.

 

[jtakw]

Hi,

Like this?

Excel 2010
	A	B	C
1	Product List	Price	After Mark Up
2	Product A	$100.00	$110.00
3	Product B	$50.00	$55.00
4	Product C	$99.00	$108.90
5	Product D	$150.00	$157.50
Sheet1

Cell Formulas
Range	Formula
C2	=IF(B2<=100,B2*1.1,B2*1.05)

Formula copied down.

 

[lesmcqueen73]

That worked perfectly... THANK YOU.

I was so going down the wrong path doing (rather not doing) it my way.

 

[jtakw]

You're welcome, welcome to the forum.