Hot answers tagged


It is not a standalone function, just two minus signs next to each other. It is used to convert boolean (TRUE / FALSE) values to number, as those not always evaluate correctly in formulas. First - converts TRUE to -1, and second one changes it to 1. First - converts FALSE to 0(, and second one doesn't change it). Can You also tell me the list of ...


You could =COUNTIF(A3:A10,"#DIV/0!") Source:


See the setup of the table below. It's from Excel 2013, so it looks different, but the idea is the same.


For the First example write an array: Column1 Column2 No Contact 01 Declined Services 02 Make sure you format the column as text in order to write 01, 02... and in the new column where you have your Data write the following: =VLOOKUP(A1,$I$1:$J$5,2,FALSE) Where: $I$1:$J$5 are the references of the above array (absolute ...

Only top voted, non community-wiki answers of a minimum length are eligible