Beege,

I don't want the formula in GR456 to change a value in another cell (GJ459).
I do want whatever value in GJ459 to be incremented by 12 and display in
GR456. In other words the value in GJ459 appears in GR456 add it by 12 and
display the value in GR456 when the value in GQ456 is CCPM. If GQ456 is a
value other than CCPM GR456 will display the same value as GJ459.

"Beege" wrote:

Lance

GQ456 is CCPM or some other value, yes?

You want GJ459 to increment, so you need a formula in GJ459 like:
=IF(GQ456="CCPM",TEXT(13,"0000"),TEXT(1,"0000"))

A formula in GR456 will not change a value in another cell (GJ459?)
If you want to use GR456 for the initial number (0001) then the formula in
GJ459 would change to:

=IF(GQ456="CCPM",TEXT(GR456+13,"0000"),TEXT(GR456, "0000"))

Beege

"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.