Unary operators
I've noticed several posts which use the unary operators "--" before
implementing some function. Why is this done? Here's an example: =--(COUNTIF(A1,"CA*")0) TIA, -- Joe VBA Automation/VB/C++/Web and DB development |
Check out
http://www.mcgimpsey.com/excel/doubleneg.html In article , Joe wrote: I've noticed several posts which use the unary operators "--" before implementing some function. Why is this done? Here's an example: =--(COUNTIF(A1,"CA*")0) |
Great explanation! It helped me go from completely clueless to .. having
SOME understanding "JE McGimpsey" wrote: Check out http://www.mcgimpsey.com/excel/doubleneg.html In article , Joe wrote: I've noticed several posts which use the unary operators "--" before implementing some function. Why is this done? Here's an example: =--(COUNTIF(A1,"CA*")0) |
Agreed! I didn't understand this either.
/Fredrik "Duke Carey" wrote in message ... Great explanation! It helped me go from completely clueless to .. having SOME understanding "JE McGimpsey" wrote: Check out http://www.mcgimpsey.com/excel/doubleneg.html In article , Joe wrote: I've noticed several posts which use the unary operators "--" before implementing some function. Why is this done? Here's an example: =--(COUNTIF(A1,"CA*")0) |
All times are GMT +1. The time now is 11:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com