A number of ways to do this. How about filtering on False in column B
and then enter -997 in all the found rows

On Thu, 23 Oct 2003 07:48:45 -0700, "DaveB"
wrote:

I have 2 columns in my worksheet:
Column A Column B
10 TRUE
0 FALSE
4 TRUE
0 FALSE
2 TRUE

For every FALSE in column B, I would like column A to be
-997.

Thanks in advace for the code.
DaveB