Dollar Range to Percentage

[Dimitri]

Have column with multiple rows with differnet dollar amounts. What I would
like to do is write a formula outlining a percentage for a dollar range:

$0 - $25,000 = 4%

Column A Column B
$10,000 4%
$15,000 4%

 

[Gary''s Student]

In B1 enter:
=IF((A1>0)*(A1<24999),4%,"") and format B1 as percentage

 

[Bob I]

B is
=IF(AND(A1>=0,A1<=25000),"4%","0%")

 

[Dimitri]

Gary:

That work's great! But here is the second part (and I do apologize to do
this in stages but I only ask after I have tried to make it work).

$0 - $25,000 = 4%
$25,000 - $50,000 = 5%
$50000 - $75,000 = 6%
$75,000 + = 7%

Column A Column B
$10,000 4%
$15,000 4%
$35,000 5%
$55,000 6%
$85,000 7%

Dimitri