need to detect syntax in value

[J.Parker]

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]

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

Regards,
Fred