ExcelBanter - Logical Test

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Logical Test (https://www.excelbanter.com/excel-worksheet-functions/77892-logical-test.html)

Lance

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.

Trevor Shuttleworth

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.

All times are GMT +1. The time now is 06:06 PM.