excellent, works a treat.

thank you


"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
news:OwGpLnaIFHA.720@TK2MSFTNGP10.phx.gbl...
> =CHOOSE(H8,0,50,75)
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Juco" <Me@nospam.fictional> wrote in message
> news:xulWd.237648$B8.183647@fe3.news.blueyonder.co.uk...
> > I have in cell N19 the formula below. I am trying get it to put in cell
> N19
> > the following
> > if H8 =2 then N19 = £50, if H8 = 3 then N19=£75, if H8 = 1 then N19 =£0
> > I have tried to amend a previous formula but with little success.
> >
> > =IF(H8="3",75,)
> >
> > help appreciated
> > thanks
> >
> >
>
>