|Posted by:||Pete_UK (pashur…@auditel.net)|
|Date:||Mon, 13 Aug 2007|
If you put a, b, c or d in A1, then this formula will return the rate
As for your other queries, you can have simple codes like Y or N in a
column (eg E) for padding charges and a formula like:
where chg is your padding charge (or rate, to be multiplied by the
area), and a formula like:
where G contains the state and x is the tax rate for state_1 and y is
the tax rate for the other state.
Hope this helps.
On Aug 14, 1:26 am, Sharri <Sha.…@discussions.microsoft.com> wrote:
> 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?
> Sharri Jinnah
> Carpet Direct
Formulas posted by Sharri on Mon, 13 Aug 2007