Re: Formulas

Giganews Newsgroups
Subject: Re: Formulas
Posted by:  Pete_UK (pashur…
Date: Mon, 13 Aug 2007

If you put a, b, c or d in A1, then this formula will return the rate
per yard:


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.…> 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?
> Thanks!
> --
> Sharri Jinnah
> Carpet Direct


In response to

Formulas posted by Sharri on Mon, 13 Aug 2007