formula for manufacturing rate card?

[jtull73]

Hi all,
I would be so grateful for any help I could get on this. My company has a new CD manufacturing rate card, and I would like to be able to set up formulas so that when we enter certain criteria (number of page in the booklet, number of discs, slipcase, etc) in certain cells, the formula(s) would spit out the appropriate costs, based on our rate card.

I've attached an excel with the rate card, etc.

On one sheet would be the rate card. On the other excel sheet would be the input/output (formula). For input, there would be 3 columns: (1) number of discs, (2) number of pages, (3) Slipcase (slipcase would be a check box, or entering an "x"). I'm assuming the actual rate card would not even need to be on a sheet, if everything was built into the formula.

In an overview, it would be something like "if 1 page, 1 CD, no slipcase = $x.xx)" "36 pages, 3 CD, slipcase = $x.xx)."

I would be very grateful for any help.

[JohnTopley]

Try

Please Login or Register  to view this content.