Sykovampyr
Board Regular
- Joined
- Nov 3, 2006
- Messages
- 71
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
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