Combine two formulas to add percentage based off of amount?

[gsmonk]

Hello All,

I have a column with prices and I need to make a formula, if the price is under 9.99 add 34% if it is over 10.00 add 24%. I know I can do “=A1*1.34 “ and “A1*1.24” separately, but how can I combine them into one formula to dynamically adjust based off A1 prices being 9.99 or below and 10.00 or above? Thanks in advance for all the help.

Thanks,

Greg

[arthurbr]

And what if price is 9.99 or 10.00 ?

[stir-crazy]

I have a column with prices and I need to make a formula, if the price is under 9.99 add 34% if it is over 10.00 add 24%. I know I can do “=A1*1.34 “ and “A1*1.24” separately, but how can I combine them into one formula to dynamically adjust based off A1 prices being 9.99 or below and 10.00 or above? Thanks in advance for all the help.

Then this is your formula:

=If(a1>9.99,a1*1.24,a1*1.34)

[shg]

That's a odd markup schedule; an item with a cost of 9.99 has a price of 13.39, and an item with a cost of 10.00 has a price of 12.40.

You could apply 34% to the first $10, and 24% thereafter, using the formula =SUMPRODUCT( (A2 > {0,10}) * (A2 - {0,10}) * {1.34,-0.1} )

Please Login or Register  to view this content.