Hi

You'll have to have a formula in GJ459. But you can't have a formula and a
value. You could have this formula in the
=IF(GQ456="CCPM",13,1)
which will show 1 unless CCPM is in GQ456, and then it would show 13

Andy.

"Lance" wrote in message
...
Cell GR456 contains the following logical test:
=IF(GQ456="CCPM",GJ459+12,GJ459). When CCPM is the option, I want the
value
in GJ459 to increment by 12 i.e. 0001 should be 0013. That does not
happen.
The value remains 0001 whether the option is CCPM or another value. How
do I
get the value in GJ459 to increment by 12 when CCPM is the option.