=IF(J9="x",1,IF(K9="x",1.5,IF(L9="x",2,IF(M9="x",2 .5,IF(N9="x",3,IF(O9="x",3.5,IF(P9="x",4,"")))))))

This works fine for me if my customers use an x, but some use a tick or a
star, or any computer letter/symbol.
Can this equation be made to work irrespective of what the entry in the cell
is?

=IF(J9<"", 1, etc.

--

HTH

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


"Robin C" <Robin wrote in message
...

=IF(J9="x",1,IF(K9="x",1.5,IF(L9="x",2,IF(M9="x",2 .5,IF(N9="x",3,IF(O9="x",3
..5,IF(P9="x",4,"")))))))

This works fine for me if my customers use an x, but some use a tick or a
star, or any computer letter/symbol.
Can this equation be made to work irrespective of what the entry in the
cell
is?

Does

=LOOKUP(2,1/(1-ISBLANK(J9:P9)),{1,1.5,2,2.5,3,3.5,4})

fit the bill?

Robin C wrote:
=IF(J9="x",1,IF(K9="x",1.5,IF(L9="x",2,IF(M9="x",2 .5,IF(N9="x",3,IF(O9="x",3.5,IF(P9="x",4,"")))))))

This works fine for me if my customers use an x, but some use a tick or a
star, or any computer letter/symbol.
Can this equation be made to work irrespective of what the entry in the cell
is?

Try this formula
=IF(I7<"",1,IF(J7<"",1.5,IF(K7<"",2,IF(L7<"",2 .5,IF
(M7<"",3,IF(N7<"",3.5,IF(O7<"",4,"")))))))
-----Original Message-----
=IF(J9="x",1,IF(K9="x",1.5,IF(L9="x",2,IF(M9="x", 2.5,IF
(N9="x",3,IF(O9="x",3.5,IF(P9="x",4,"")))))))

This works fine for me if my customers use an x, but
some use a tick or a
star, or any computer letter/symbol.
Can this equation be made to work irrespective of what
the entry in the cell
is?
.