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

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

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

If the percentage to be applied to amounts over 25 is only 3.5%, then this
should do what you want...

=0.0875*MIN(B2,25)+0.035*MAX(B2-25,0)

However, if the percentage to be applied to numbers over 25 is 8.75% PLUS
3.5%, then you probably want this instead...

=0.0875*B2+0.035*MAX(B2-25,0)

I think you want the first formula, but I wasn't completely clear on what
percentage applied to amounts over 25, so I gave you the second formula just
in case.

--
Rick (MVP - Excel)


"amsmith" wrote in message
...
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

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

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

It is true that I need to show: that the first $25 is at 8.75%----what 8.75%
of $5.50 is, and show it as .48. but also if I have $60, then I need to show
what is 8.75% of $25_____+ what is 3.50% of $35______. (The two Totals added
for one amount being deducted). I am really stumped, and I apologize if I
confuse you! I understand if this fustrates you too much!
Thanks for your help and ideas.
--
Thanks!
Mandy


"Rick Rothstein" wrote:

If the percentage to be applied to amounts over 25 is only 3.5%, then this
should do what you want...

=0.0875*MIN(B2,25)+0.035*MAX(B2-25,0)

However, if the percentage to be applied to numbers over 25 is 8.75% PLUS
3.5%, then you probably want this instead...

=0.0875*B2+0.035*MAX(B2-25,0)

I think you want the first formula, but I wasn't completely clear on what
percentage applied to amounts over 25, so I gave you the second formula just
in case.

--
Rick (MVP - Excel)


"amsmith" wrote in message
...
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

The first formula I posted does that...

=0.0875*MIN(B2,25)+0.035*MAX(B2-25,0)

--
Rick (MVP - Excel)


"amsmith" wrote in message
...
It is true that I need to show: that the first $25 is at 8.75%----what
8.75%
of $5.50 is, and show it as .48. but also if I have $60, then I need to
show
what is 8.75% of $25_____+ what is 3.50% of $35______. (The two Totals
added
for one amount being deducted). I am really stumped, and I apologize if I
confuse you! I understand if this fustrates you too much!
Thanks for your help and ideas.
--
Thanks!
Mandy


"Rick Rothstein" wrote:

If the percentage to be applied to amounts over 25 is only 3.5%, then
this
should do what you want...

=0.0875*MIN(B2,25)+0.035*MAX(B2-25,0)

However, if the percentage to be applied to numbers over 25 is 8.75% PLUS
3.5%, then you probably want this instead...

=0.0875*B2+0.035*MAX(B2-25,0)

I think you want the first formula, but I wasn't completely clear on what
percentage applied to amounts over 25, so I gave you the second formula
just
in case.

--
Rick (MVP - Excel)


"amsmith" wrote in message
...
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

Wondering...what do you want to happen if B2 is greater than 1000??
--
smither fan


"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