Conditional Function
How about something like this, which assumes your $10K or $20K is in A8
=IF(A8<=10000,A8*0.1,((10000 *0.05) +((A8-10000)*0.1)))
"Lisa H" wrote:
I am trying to create a formula that will multiply a portion of a cell by a
percent and the other portion by another percent. For example, when the value
reaches $10,000 I want it to multiply by a different percent. So, if the
value is 20,000 I want to multiply 10,000 by 5% and the other 10,000 by 10%.
Any ideas?
|