Hi again,

And another short version, this time of the IF

=1.03*(IF(A1100,2,IF(A1225,3,1))*5+A1)

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"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