Anything over 1550 has a straight 3% markup. Every other cost has a dollar
amount mark up. The additional 3% is added on after to cover my merchant
fees that I pay. Hopefully that will help make sense of the values I need :)
So for anything over 1550 it either needs to go up 3% twice, or 6% once.
Whichever is an easier formula.

Where I'm really confused is where and how to put in the formula. Do I
click "formulas" then "add function"? After that it asks for different
values and I'm not sure what to put in. Sorry, but I've never worked with
this kind of thing in excel and I'm really confused.
--
Thanks :) Lori


"Ragdyer" wrote:

I don't understand your formula (explanation) for the last value that's over
1550.

Could you rephrase it?

To see if I understand what you're looking for, let's temporarily say you
only have 8 breaks, ending at over 1000.

With your costs starting in F2, try this formula in G2:

=F2+LOOKUP(F2,{0,50.01,100.01,225.01,400.01,575.01 ,700.01,1000.01;5.15,8.24,
10.3,15.45,20.6,30.9,41.2,51.5})

And copy down as needed.
If this performs as you wish (up to the 1000 level), post back with a
clarification of your maximum price break calculation,
and I'll include it into the formula for you, if you don't think you can do
it yourself.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Lori" wrote in message
...
First I want to thank everyone who tried to help.

Second, I apparenlty need my hand held thru this whole process. I tried
using the formula =(A1+LOOKUP(A1,{0,100.01,225.01},{5,10,15}))*1.03 but
apparenlty don't know where to put it!

Here's how my file is set up...

It's saved as excel 97-03 workbook even tho i'm running it in excel 2007

It's got a frozen row on top

A=manufacturer
B=Item number
C=to check item (column is actually blank)
D=Inventory
E=Check cost
F=Cost (this is the one I need to calculate from. when I was trying the
formula tho, I copied this column to a different sheet and had it in
column A
without any header)
G=Price (this is where I need the calcualtions to end up)

I tried going to Formulas-Insert Function. But since I have no idea what
I'm doing I didn't know where to go from there :(

I understand that I need to insert the correct column letter into the
formula but other than that I'm still lost :(

Here's what all the formulas (price breaks) will be.

0-50 plus 5 times 1.03
50-100 plus 8 times 1.03
100-225 plus 10 times 1.03
225-400 plus 15 times 1.03
400-575 plus 20 times 1.03
575-700 plus 30 times 1.03
700-1000 plus 40 times 1.03
1000-1550 plus 50 times 1.03
1550 and over times 1.06 (or if it's easier times 1.03 and times 1.03)

Thank you in advance for helping me with this!!!
--
Thanks :) Lori


"Lori" wrote:

Oh crud...it's me again. I didn't put this in before.

0-100 in column A. Add $5 and multiply by 1.03 to give me a value in
column
B.

100.01-225 in column A. Add $10 and multiply by 1.03 for value in
column B.

225.01-400 in column A. Add $15 and multiply by 1.03 for value in
column B.

I just want to be sure if I do something like put 100.01-225 in the
formula
you gave me it will work.

Also, do I copy/paste the entire formula (there's a total of 9 different
price breaks I need to use) down column B?

Sorry if I'm sounding stupid, but I really can't mess this up :o

--
Thanks again :) Lori


"Lori" wrote:

Hi all!

I have a column with different numers (actually prices). I want to be
able
to set something up so each number can be given a certain value in the
next
column. This is hard to explain and I hope I make sense...

Column A will have various numbers. I'd like to make a rule that
says...

0-100 in column A. Add $5 and multiply by 1.03 to give me a value in
column
B.

100.01 in column A. Add $10 and multiply by 1.03 to give me a value
in
column B.

Is this possible? I've researched until my head spins and can't
figure out
how to do it. I'm hoping someone here who know a lot more about Excel
2007
can help me out!
--
Thanks :) Lori