| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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)) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Detect Duplicates | Excel Worksheet Functions | |||
| How to detect #N/A and return 0? | Excel Discussion (Misc queries) | |||
| How to detect changes in a column? | Excel Discussion (Misc queries) | |||
| how to detect 5th character? | Excel Discussion (Misc queries) | |||
| Is there a function to detect changes in any given cell? | Excel Worksheet Functions | |||
Linear Mode
