Excel Help Needed......

[Big Bad Nige]

Can anyone help me, Im trying to create a data sheet, basically I need to
enter a height value, then I need it to look at the value entered for the
height and if its up to 350mm then it must add 35% to a second value, if its
up to 600mm then it must add 40% to a second value and so on and on. Im not
sure if i should be using lookup function or an IF function ? Any pointers
would be appreaciated. Nige

[Bob Phillips]

Create a table in say M1:N20 with values of 0, 25%;350,40%; etc. and then
assuming the lookup value is in E1 and the value to be added to is D1, use

=D1*(1+VLOOKUP(E1,M1:N20,2))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Big Bad Nige" <BigBadNige@discussions.microsoft.com> wrote in message
news:56E71EA0-3D2F-4EA0-A16E-0999BED645B9@microsoft.com...
> Can anyone help me, Im trying to create a data sheet, basically I need to
> enter a height value, then I need it to look at the value entered for the
> height and if its up to 350mm then it must add 35% to a second value, if
its
> up to 600mm then it must add 40% to a second value and so on and on. Im
not
> sure if i should be using lookup function or an IF function ? Any pointers
> would be appreaciated. Nige

[Big Bad Nige]

Thanks for the speedy reply and spot on advice !! Appreaciated.

"Bob Phillips" wrote:

> Create a table in say M1:N20 with values of 0, 25%;350,40%; etc. and then
> assuming the lookup value is in E1 and the value to be added to is D1, use
>
> =D1*(1+VLOOKUP(E1,M1:N20,2))
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "Big Bad Nige" <BigBadNige@discussions.microsoft.com> wrote in message
> news:56E71EA0-3D2F-4EA0-A16E-0999BED645B9@microsoft.com...
> > Can anyone help me, Im trying to create a data sheet, basically I need to
> > enter a height value, then I need it to look at the value entered for the
> > height and if its up to 350mm then it must add 35% to a second value, if
> its
> > up to 600mm then it must add 40% to a second value and so on and on. Im
> not
> > sure if i should be using lookup function or an IF function ? Any pointers
> > would be appreaciated. Nige
>
>
>