View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Per Jessen Per Jessen is offline
external usenet poster
 
Posts: 1,533
Default Need help I do. Percentage Formula ASAP Please

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