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
|