Respectfully, I understand that Ardus. I am looking for a formula or If
statement that will increment and display in Cell GR456 the value of Cell
GK460 by 12 when "CCPM" is the option in Cell GQ456. Keep in mind that the
value in Cell GK460 changes

"Ardus Petus" wrote:

Your IF formula won't change the contents of cell GJ459.

HTH
--
AP

"Lance" a écrit dans le message de
...
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.