Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Logical Test
=IF(GQ456="CCPM",("GK460+12"),("GK460")) I'm expecting a numeric result to
this test. However, I don't get one. Cell GQ456 is populated with either CCPM or FLR. If it is CCPM the result should be 12 plus the number in cell GK460. If cell GQ456 is not populated with CCPM the result should be what the number is in cell GK460. I'm not getting the expected result. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Logical Test
=IF(GQ456="CCPM",GK460+12,GK460)
Regards Trevor "Lance" wrote in message ... =IF(GQ456="CCPM",("GK460+12"),("GK460")) I'm expecting a numeric result to this test. However, I don't get one. Cell GQ456 is populated with either CCPM or FLR. If it is CCPM the result should be 12 plus the number in cell GK460. If cell GQ456 is not populated with CCPM the result should be what the number is in cell GK460. I'm not getting the expected result. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A logical test in the If function for blank, i.e., If blank? | Excel Worksheet Functions | |||
Concatenate a Logical Test | Excel Discussion (Misc queries) | |||
Is there a logical test for a cell's format instead of contents | Excel Worksheet Functions | |||
=IF logical test to search only part of a cell | Excel Worksheet Functions | |||
logical test - within a range | Excel Worksheet Functions |