=CHOOSE(H8,0,50,75)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Juco" wrote in message
.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