An Easy question......

[Sykovampyr]

Hi Guys,

I have a table with 5 columns (A-E) with information in each Column. Column D contains a % value and cloumn E contains a value. I need a formula to go in Column F to pick up the % value and if it is >1% it returns a 0 value, 1-2% returns 1, 2-2.5% returns 3, 2-3% returns 5 and over 3% returns the value 10. I got in a mess with the conditional formatting........

Cloumn G i need the same formula but relating to items but I can work this out form the above.


I would also like to update this every four weeks with additional data and in Cloumn A there is a list of Names / Items that will have some new data and some duplicate each week. Will the formula be able to consolidate this data?


Does this makes sense?

I am using Excel 2007

 

[Yard]

THink you've got some logic mixed up in your percentage boundaries, but something like this might get you started:

=LOOKUP(D1,{0,0.01,0.02,0.025,0.03},{0,1,3,5,10})

 

[Sykovampyr]

Yard, You ARE a LEGEND!

Thank you for this!