Hello,
I have three tables
The first two tables contain bandings greater or less than the next band level, so if the relevant value for band 1 is 155,000 the percentage would be 0.5%. I need a formula in the last table that returns the relevant percentage figures from the other two tables combined based on the figures against Band 1 or Band 2 in this third table. i.e. if Band 1 is 155,000 and Band 2 is £3,152,000 it would return 2%.
Any and all help greatly appreciated as always.
I have three tables
Band 1 | Percentage |
£ 150,000 | 0.50% |
£ 250,000 | 1.00% |
£ 350,000 | 1.50% |
£ 450,000 | 2.00% |
£ 600,000 | 2.50% |
£ 1,000,000 | |
Band 2 | Percentage |
£ 2,500,000 | 0.5% |
£ 2,750,000 | 1.0% |
£ 3,000,000 | 1.5% |
£ 3,250,000 | 2.0% |
£ 3,500,000 | 2.5% |
£ 4,000,000 | |
Column1 | Column2 |
Band 1 | £ 155,000 |
Band 2 | £ 3,152,000 |
Percentage | |
The first two tables contain bandings greater or less than the next band level, so if the relevant value for band 1 is 155,000 the percentage would be 0.5%. I need a formula in the last table that returns the relevant percentage figures from the other two tables combined based on the figures against Band 1 or Band 2 in this third table. i.e. if Band 1 is 155,000 and Band 2 is £3,152,000 it would return 2%.
Any and all help greatly appreciated as always.