Calculating Commisions based on a range of values

Giganews Newsgroups
Subject: Calculating Commisions based on a range of values
Posted by:  Dianna Arambula (dianna…@hotmail.com)
Date: Fri, 3 Oct 2003

I am trying to calculate a commision that is based on a
sales price.  The example commision is a fixed fee for 1-
225000, 225001-275000, 275001-40000, ....  For what ever
reason I have been unable to figure out how to accomplish
this.  Ideally I can write a formula that checks the
sales price and determines the appropriate commision.

So
Sales Price    Comm
$225,000        $2,000
$300,000        $2,500
$450,000        $4,000

Any advice and help is greatly appreciated!!  Thanks to
all you excel wizards for your help....

Replies