| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If statement where the logical test is a range that equals a word | Excel Worksheet Functions | |||
| if logical test true, then hlookup, if false then difference betwe | Excel Worksheet Functions | |||
| An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions | |||
| test for date in column question | Excel Worksheet Functions | |||
| Follow on from simple question 12/8/2004 | Excel Discussion (Misc queries) | |||
Threaded Mode
