Wayne_Sadler
Board Regular
- Joined
- Jan 7, 2005
- Messages
- 148
a range I think
He's an example
I type in a value say A1 for example
I want A2 to lookup a varble range ie
if it's between
0 - 100 = 10
100 - 200 = 18
200 - 300 = 25
so A2 would give the answer of 18 if the A1 field said 156 say
I hope I've expalined my self
many thanks Wayne
Any advice welcome
He's an example
I type in a value say A1 for example
I want A2 to lookup a varble range ie
if it's between
0 - 100 = 10
100 - 200 = 18
200 - 300 = 25
so A2 would give the answer of 18 if the A1 field said 156 say
I hope I've expalined my self
many thanks Wayne
Any advice welcome