Thread: Logical Test
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lance
 
Posts: n/a
Default 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.