View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lance
 
Posts: n/a
Default Follow-up to Logical Test Question

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.