I need to create a four varible pricing matrix for my sales reps.  The
following variables will affect the price.

if distance increases, then price decreases
if reward increases, then price increases
if attempts increase, then price increases
if skill level increases, then price increases

there is a minimum distance of 150, below which pricing is not allowed and
a maximum distance of 200, above which pricing is not effected.


there are 3 skill levels, 0=novice
                         1=intermediate
                         2=skilled

How do I create the formula or matrix or spreadsheet???

Any suggestions or assistance will be greatly appreciated!!!