Okay...I measure for carpet and hardwood floor and have created a spreadsheet
to calculate the costs for me. The problem I am having is that there are
variables within a cell. For example, we charge either $4, $4.25, $4.50 or
$5.00 per yard per install. I would like to be able to put in a, b, c, or d
and have it calculate the cost associated with that letter. Also, there is
always a shipping charge but only sometimes a padding charge. I am on the
border of 2 states, so the tax changes based on that. Are there simple
formulas that can calculate these items?

Thanks!
--
Sharri Jinnah
Carpet Direct