Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas
=E1*(CHOOSE(CODE(A1)-96,4,4.25,4.5,5)*B1+C1+D1)
Where A1 contains the code for price by yard either a or b or c or d Where B1 contains the number of yards Where C1conains the shipping charge Where D1 contains the paddding charge -- Gary''s Student - gsnu200737 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas
If you put a, b, c or d in A1, then this formula will return the rate
per yard: =CHOOSE(CODE(A1)-96,4,4.25,4.5,5) 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: =IF(E1="Y",chg,0) where chg is your padding charge (or rate, to be multiplied by the area), and a formula like: =IF(G1="state_1",x,y) 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. Pete On Aug 14, 1:26 am, Sharri 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas
Pete, Can I send this file to you for review? I've added comments for
better explanation... :) -- Sharri Jinnah Carpet Direct "Pete_UK" wrote: If you put a, b, c or d in A1, then this formula will return the rate per yard: =CHOOSE(CODE(A1)-96,4,4.25,4.5,5) 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: =IF(E1="Y",chg,0) where chg is your padding charge (or rate, to be multiplied by the area), and a formula like: =IF(G1="state_1",x,y) 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. Pete On Aug 14, 1:26 am, Sharri 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |