Hi All
What formula/s do i need to return a value based on a number being between two other numbers.
E.G.
A B D
1 £- £1,000 12
2 £1,000 £3,000 14
3 £3,000 £4,000 16
4 £4,000 £6,000 18
5 £6,000 £1,000 20
6 any value
IF A6 lies between any of the values in columns A & B then return the relevant value in D
What formula/s do i need to return a value based on a number being between two other numbers.
E.G.
A B D
1 £- £1,000 12
2 £1,000 £3,000 14
3 £3,000 £4,000 16
4 £4,000 £6,000 18
5 £6,000 £1,000 20
6 any value
IF A6 lies between any of the values in columns A & B then return the relevant value in D