|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.
Sales Price Comm
Any advice and help is greatly appreciated!! Thanks to
all you excel wizards for your help....