Let's say the first number is in A2
In B2 enter the formula =IF(A2<=100,(A2+5)*1.03, =(A2+10)*1.03)
Copy this down the column (the quickest way is to double click B2's fill
handle - the small solid square in lower right cornet when B2 is selected)
Another formula that would work is =((A2<=100)*(A2+5)
+(A2100)*(A2+10))*1.03
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"Lori" wrote in message
...
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