- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2007 August
- Formulas

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

- RE: Formulas posted by Gary''s Student on Mon, 13 Aug 2007
- Re: Formulas posted by Pete_UK on Mon, 13 Aug 2007