=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.