Hi, I need help with some a formula please, I have the following data...
Product code, Qty, Price,Item Code,Comments,Date Returned.
(The comments header indicates whether the stock is old/new or to be refurbished.)
What I need to do is to work out the worth of an item depending on date returned/new/refurbished etc.
If a product is more than 6 months old then - 30% off price.
If a product is more than 9 months old then - 60% off price.
If product price is less than £10.00 then write off completely at 6 months
For 'refurbish' products, a cost of 25% must be deducted from the price. This should be done before calculating whether a product's value is less than £10.00.
OK I hope i've made this so its understandable
What I need is a formula that will work this out for me please. (I'm not allowed macros by the way)
Thanks for any help as I'm really stuck on this.
Anx
Product code, Qty, Price,Item Code,Comments,Date Returned.
(The comments header indicates whether the stock is old/new or to be refurbished.)
What I need to do is to work out the worth of an item depending on date returned/new/refurbished etc.
If a product is more than 6 months old then - 30% off price.
If a product is more than 9 months old then - 60% off price.
If product price is less than £10.00 then write off completely at 6 months
For 'refurbish' products, a cost of 25% must be deducted from the price. This should be done before calculating whether a product's value is less than £10.00.
OK I hope i've made this so its understandable
What I need is a formula that will work this out for me please. (I'm not allowed macros by the way)
Thanks for any help as I'm really stuck on this.
Anx