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%

Dimitri

 

[Gord Dibben]

=LOOKUP(A1,{0,25001,50001},{4,5,6})

Adjust to suit for dollar ranges and percentages.


Gord Dibben MS Excel MVP

 

[Dimitri]

AWESOME!!!!!!!!!!!!!!!

Dimitri

=LOOKUP(A1,{0,25001,50001},{4,5,6})

Adjust to suit for dollar ranges and percentages.


Gord Dibben MS Excel MVP

 

[Dimitri]

Gord:

This is still AWESOME but there is one small thing. If Column A = 0, I am
getting 4% but need 0%.

Dimitri