| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Contains Word
Hi
I have the following formula but am having some difficulty with the last bit. If cell G7 contains the word "Total" I want the result to be 0 if the rest of the criteria is not met. so if cell G7 = "London Total" I want the result to be 0 =IF(A7="Y",COUNTIF(J7:Q7,"(blank)"),IF(A7="N",10,I F(SEARCH("Total",G7),0,0))) the rest of the formula works fine... Many thanks for your help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to copy the first word or two words from a cell containing a complete sentence to another cell | Excel Discussion (Misc queries) | |||
| word match in string text in cell, color format cell | Excel Discussion (Misc queries) | |||
| How do a put a word on top of a word in a cell? | Excel Discussion (Misc queries) | |||
| Add word in cell changes to word TRUE | Excel Discussion (Misc queries) | |||
| how do I make a word typed in a cell go to a specific cell in anot | Excel Discussion (Misc queries) | |||
Threaded Mode
