need to detect syntax in value

J

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))
 
F

Fred Smith

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

Regards,
Fred
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

15 minutes early 5
Excel Help to copy information from one row at a time to another sheet 1
How do I automatically generate a worksheet. 1
changing color of answer 1
Excel JUMP FROM SEARCH BAR TO RESULT 3
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
count blank cells to next value 7
help with the syntax for using range name in a formula? 2

Top