Thank you thank you thank you! And it's no wonder I had a headache trying to
figure it out :) Um, would you believe I got straight A's in math related
courses and was even taking college Algebra when I was in high school :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