| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Without it the formula will return TRUE or FALSE. The -- will convert TRUE
to 1 and FALSE to 0 http://www.mcgimpsey.com/excel/formulae/doubleneg.html -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Tim Sampson" wrote in message . 2... "Ken Wright" wrote in news:#LEJasDFFHA.4072 @TK2MSFTNGP10.phx.gbl: =--(COUNTIF(A1,"*fred*")0) What is the =-- for? Tim |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Hybrid Mode
