L
Leslie Isaacs
Hello All
I want to assign a value to each cell in a column according to the value in
the same row of the previous column, as follows:
if the cell in the previous column includes the word "hospital", the
assigned valus should be 1 - otherwise it should be 2.
I have tried:
=if (G2=*hospital*,1,2)
and
=if (G2=*"hospital"*,1,2)
and
=if (G2 like "hospital",1,2)
but none of them work!
I would be very grateful is someone could give me the correct syntax.
May thanks
Leslie Isaacs
I want to assign a value to each cell in a column according to the value in
the same row of the previous column, as follows:
if the cell in the previous column includes the word "hospital", the
assigned valus should be 1 - otherwise it should be 2.
I have tried:
=if (G2=*hospital*,1,2)
and
=if (G2=*"hospital"*,1,2)
and
=if (G2 like "hospital",1,2)
but none of them work!
I would be very grateful is someone could give me the correct syntax.
May thanks
Leslie Isaacs