So, lets say I have columns A, B, C with the three dropdown boxes. In column D I have a quantity which I manually input. Then, in column F, what I want to do is basically look at columns A, B, and C, and determine a base cost, then multiply it by column D (the quantity), to get my price for column F.

Does this make sense?

I've been trying to do this in VBA, but I'm not an advanced user of VBA so I do not know all the ways to get things done. But I do understand most logic behind specific lines of code, so I'm not totally oblivious.

Basically, I think what I need is something like this:

If A1 = this, and B1 = this, and C1 = this, then F1 = D1*0.50

The 0.50 will be determined based on the choices of A, B, C. Does this make sense?

To further elaborate. Let me throw an example of the types of things in these dropdown boxes.

EXAMPLE:

A1- B&W, Color

B1- Letter, Ledger

C1- 20#, 80#

So, A1 we will choose whether the print is black and white, or color. B1 will choose whether it is on letter size paper, or ledger. And C1 will choose the weight of the paper. All of which will adjust the cost of each print.

I would greatly appreciate any help or insight to getting this code written. Thanks in advance!