You can multiply the boolean expression with 1
(m=2)*1

Frank

sphenisc wrote:
Can I convert a boolean expression e.g. (m=2), into a 1 or
0 during a VBA calculation without resorting to if
statements or the like?

Thanks