View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dimitri Dimitri is offline
external usenet poster
 
Posts: 12
Default 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% - how do I acheive this through formula
$15,000 4%