Formulas

Giganews Newsgroups
Subject: Formulas
Posted by:  Sharri
Date: Mon, 13 Aug 2007

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

Replies