Point well taken, it was just force of habit and lazy thinking on my part.

David Biddulph wrote:
Would you like to explain why you've got a double unary minus? If you are
trying to convert from boolean to a number, any arithmetic operation will do
it. Two negations is a way if you're not doing any other arithmetic, but as
you've got a multiplication I can't see the need for the double negation.
--
David Biddulph

"smartin" wrote in message
...
Perhaps on rows 2 and fill down is

=B1+A2-35*(--B135)