Your formula idea seemed to have all the components that I need, but it only
gave me a zero. Any other ideas, as to how I can either show what 8.75% of
$5.50 as..48?
Thanks so much for your ideas.
--
Thanks!
Mandy


"FSt1" wrote:

hi
this seems to be working...try it out.
=IF(B2<26, B2*0.0875,IF(AND(B225,B2<1000),(B2-25)*0.035+(25*0.0875),0))

regards
FSt1

"amsmith" wrote:

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