Dave,

I would probably use a Vlookup table to accomplish this.

For example:

G1: A
G2: B
G3: C
etc.

H1: .5
H2: .55
H3: .6
etc.

A3: =A1 * VLookup(A2,G1:H7,2,False)

Does that work?

"Dave" wrote:

A1 is Price
A2 we would enter letters A - G
A3 If A2 is A multiply A1 by 50%
If A2 is B multiply A1 by 55%
etcetera
I Can't seem to create a formula that works.
--
Dave1125