formula for adjusting price
 

can anyone help on this: lets say i have a cost for an item in c2, its
inventory age in c3, and a price column in c1. can i formula so that when i
enter 1 into age, it multiplies cost times a set amount, 2 multiplies by
another amount, 3 times another, and so one. my goal is to have new pricing
generated by entering a different age of product.

formula for adjusting price
 

If you only have a "few" age variables you can use something like this:

=C2*IF(C3=1,10,IF(C3=2,15,IF(C3=3,17,0)))

If you have a lot of age variables then you should create a 2 column table
like this:

...........J..........K
1.......1..........10
2.......2..........15
3.......3..........17

Then your formula becomes:

=C2*IF(C3="",0,VLOOKUP(C3,J1:K3,2,0))

--
Biff
Microsoft Excel MVP


"jtretynski" wrote in message
...
can anyone help on this: lets say i have a cost for an item in c2, its
inventory age in c3, and a price column in c1. can i formula so that when
i
enter 1 into age, it multiplies cost times a set amount, 2 multiplies by
another amount, 3 times another, and so one. my goal is to have new
pricing
generated by entering a different age of product.