ExcelBanter - need to detect syntax in value

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - need to detect syntax in value (https://www.excelbanter.com/excel-discussion-misc-queries/256207-need-detect-syntax-value.html)

J.Parker

need to detect syntax in value

I'm trying to display Cxld in the cell for my sum when cxld is detected in
the cell not a numerical value. here is what i though would be the correct
formula =IF(B7=cxld,"CXLD",(C7-B7))

Fred Smith[_4_]

need to detect syntax in value

You need quotes around both strings. Use:
=if(b7="cxld","CXLD",c7-b7)

Regards,
Fred

"J.Parker" wrote in message
...
I'm trying to display Cxld in the cell for my sum when cxld is detected in
the cell not a numerical value. here is what i though would be the correct
formula =IF(B7=cxld,"CXLD",(C7-B7))

All times are GMT +1. The time now is 10:37 AM.