Juco wrote:
> I have in cell N19 the formula below.
> I am trying get it to put in cell N19 the following
> if H8 =3D2 then N19 =3D =A350, if H8 =3D 3 then N19=3D=A375, if H8 =3D 1=
then
N19 =3D=A30
> I have tried to amend a previous formula but with little success.
> =3DIF(H8=3D"3",75,)

=3Dif(h8 =3D 2, 50, if(h8 =3D 3, 75, 0))

Please note that 2 and 3 are not quoted. Quoting
"2" and "3" are strings, not values.

That formula returns 0 if h8 is anything other than
2 or 3, not just when h8 =3D 1. If you want something
else for the h8 <> 1 case, you can do:

=3Dif(h8 =3D 2, 50, if(h8 =3D 3, 75, if(h8 =3D 1, 0, -1)))

substituting whatever value you want for -1.

(Note: -1 is probably a poor choice. But it depends
on your application.)

I think this shows you, in general, how to "amend"
your original formula. However, some of the other
responses show more elegant approaches, which may or
may not work as well, depending on your requirements.