# Sales??

Posted by Jon on September 19, 2001 12:38 PM

Problem. 3 price breaks.....

below \$5000 60%
between \$5000 and \$10,000 55%
above \$10,000 50%

I need to figure the percent of a cell if that cell is in the above range....
Example \$5500 formula result 55% of \$5500
or \$12,000 formula result 50% of \$12,000

Posted by Aladin Akyurek on September 19, 2001 12:48 PM

Jon,

Try this Boolean formulation:

=(A1&LT;5000)*(A1*60%)+(A1>=5000)*(A1&LT;=10000)*(A1*55%)+(A1>10000)*(A1*50%)

Copy down as needed.

=======

Posted by IML on September 19, 2001 1:09 PM

=+A1*0.5+(A1 &LT; 10000)*0.05*A1+(A1 &LT; 5000)*0.05*A1
good luck

Posted by Larry Bruce on September 19, 2001 5:10 PM

Jon,

Here's yet another way:

=IF(A1>10000,.5*A1,IF(A1>4999,.55*A1,.6*A1))

/s/ Larry

Posted by Aladin Akyurek on September 19, 2001 10:29 PM

> Here's yet another way:

> =IF(A1>10000,.5*A1,IF(A1>4999,.55*A1,.6*A1))

Larry --

That's right. My motive for going boolean is that such a formula evaluates faster than the IF-equivalent. The difference should be noticeable on very large sets of data.

Regards.