Please point me in the right direction for looking up within

[Wayne_Sadler]

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

 

[Aladin Akyurek]

I sort of there but having problems with the NAME BOX bit and the "TABLE"

I Select A2 to B5 I got A2 in the NAME BOX I can type "TABLE" but it does not stay in goes and there no X or Green Tick for the Fx Box

What am I doing wrong ?

I feel a right muppet...

Many thanks wayne

Hit enter immediately after typing TABLE in the Name Box while A2:B5 stays selected.

 

[Wayne_Sadler]

OK I been playing

Have a spot of bother I have been reading this site

http://www.mcgimpsey.com/excel/variablerate.html

Very interesting however when I have tried I get the wrong answer...

This is was I'm trying to achieve


At 29.99 there is a 5.25% Charge = 1.57
At 10.01 there is a 3.25% Charge = 0.33
TOT 40.00 _________________________1.90

I have been using this line

=SUMPRODUCT(--(A1>{0;29.99;100}), (A1-{0;29.99;100}), {0.0525;0.002;0})

However I get 2.12 with string above as a answer

The 5.25% works and from what I been reading

I minus 3.25 from 5.25 which gives the 0.002

So where have I gone wrong on this line of code... Any ideas any one

All advice welcome

Many thanks Wayne