Dollar Range to Percentage
 

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%

Dollar Range to Percentage
 

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

--
Gary''s Student - gsnu200770


"Dimitri" wrote:

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%

Dollar Range to Percentage
 

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

Dimitri wrote:

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%

Dollar Range to Percentage
 

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


"Gary''s Student" wrote:

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

--
Gary''s Student - gsnu200770


"Dimitri" wrote:

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%