Need help I do. Percentage Formula ASAP Please

A

amsmith

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 B2>25, but <=1000, then 3.50% + 8.75% of the first 25

Can someone out there help me? I would greatly appreciate it!
 
P

Per Jessen

Hi Mandy

If I get it right, this should do it:

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

Regards,
Per
 
F

FSt1

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

regards
FSt1
 
R

Rick Rothstein

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.
 
A

amsmith

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 said:
Hi Mandy

If I get it right, this should do it:

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

Regards,
Per
Click to expand...
 
A

amsmith

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.
 
A

amsmith

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 said:
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.
Click to expand...
 
R

Rick Rothstein

The first formula I posted does that...

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

--
Rick (MVP - Excel)


amsmith said:
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.
Click to expand...
 
Top