Okay, so when I tried this, it gave me a number but the number was incorrect.
Explanation:
B2 C2 Showed me 2.1875 Im looking for
..48 or 5.02
$5.50 your formula
I thank you very much for oyur idea. I think it was close. I have been
stumped by this for a while now.
--
Thanks!
Mandy


"Per Jessen" wrote:

Hi Mandy

If I get it right, this should do it:

=(MIN(B2,25)*0.0875)+IF(B225,(MIN(B2,1000)-25)*0.035,0)

Regards,
Per

"amsmith" skrev i meddelelsen
...
Example of what I need to do! Hope it makes sense, I hope Excel is able to
do
this.

In C2:
If B2<=25, then 8.75%
If B225, but <=1000, then 3.50% + 8.75% of the first 25

Can someone out there help me? I would greatly appreciate it!
--
Thanks!
Mandy