How can I get Microsoft excel to calculate increasing number again

[Anna]

I am a small business owner and what I need is to price my inventory. Let's
say my lowest cost ($0.01) will be multiplied by 20%....and my highest cost (
$10.000) will be multiplied by 2%?
Is there a formula to do it and if yes,,,what it is?
Somebody suggested I should use the Conditional Formatting/Formula. Is it
the best for my need and if yes, how do I do it?
Can you give me more details?

Thanks in advance!

 

[NBVC]

Conditional Formatting is for colouring or formatting the cells that you
want highlighted...

You need to better explain what you are trying to accomplish... are
you only wanting to multiply the minimum and maximum numbers by new
numbers, etc...

 

[Anna]

Thank you for your fast answer.

What I am trying to do is basically to be able to have regressing percentage
against my increasing cost.

My cost is in a column sorted from lowest to highest . I want to be able to
add on the next column a formula with which with one click to apply this
formula to all the cells in the same column (as we do with all formulas).

So,,,if at the starting point of $0.01cost I have in the formula added 20%
[sum= A1*1.20], at the end of my cost list to have only 2% added [
sum=A12510*1.02].


Sample of what I am trying to accomplish:

$50 x 12%
$ 51 x 11.99%
$ 52 x 11.98%
$ 53 x 11.97% and so on...


How do I do it?
Thanks again for your help!

 

[Shane Devenshire]

Hi,

Set up a rate table like
0.01 20%
100 19%
500 18%
....
10,000 2%

suppose this is in the range M1:N20

then use a lookup function

=VLOOKUP(A2,$M$1:$N$20,2,TRUE)*A2

Where A2 contains the cost of an item.

 

[NBVC]

Thank you for your fast answer.

What I am trying to do is basically to be able to have regressing
percentage
against my increasing cost.

My cost is in a column sorted from lowest to highest . I want to be
able to
add on the next column a formula with which with one click to apply
this
formula to all the cells in the same column (as we do with all
formulas).

So,,,if at the starting point of $0.01cost I have in the formula added
20%
[sum= A1*1.20], at the end of my cost list to have only 2% added [
sum=A12510*1.02].


Sample of what I am trying to accomplish:

$50 x 12%
$ 51 x 11.99%
$ 52 x 11.98%
$ 53 x 11.97% and so on...


How do I do it?
Thanks again for your help!

Say you have your costs currently in A2, downwards...

Use an input cell for starting rate of 12% or 0.012(e.g. Cell D1) and
another input cell for the change in rate. of 0.01% or 0.0001 (e.g. Cell
E1)... then use formula in B2, copied down..

=A2*($D$1-($E$1*(ROW($A1)-1)))

You can change your input values as needed to automatically update
formula results...