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.

=IF(GQ456="CCPM",GK460+12,GK460)

Regards

Trevor


"Lance" <Lance@discussions.microsoft.com> wrote in message
news:9A60F266-6CFB-4D18-9F92-25F67EF69F2D@microsoft.com...
> =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.