"--" operator in a formula
I tried looking under Excel's help, but it did not produce any results.
In another question, I was given a SUMPRODUCT formula which had "--" < those 2 characters before my range. Can someone tell me what the significance of the characters in the formula are? Or point me to a website that explains? I feel much more comfortable when I completely understand the formula I am writing. Thank you! |
Try the 2* responses in this previous post:
http://tinyurl.com/64py9 *Bob Phillips' link to his page, and Jason's example and explanation, with a nice touch on its evolution -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Arla M" wrote: I tried looking under Excel's help, but it did not produce any results. In another question, I was given a SUMPRODUCT formula which had "--" < those 2 characters before my range. Can someone tell me what the significance of the characters in the formula are? Or point me to a website that explains? I feel much more comfortable when I completely understand the formula I am writing. Thank you! |
See also JE McGimpsey's:
http://www.mcgimpsey.com/excel/formulae/doubleneg.html -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- |
All times are GMT +1. The time now is 02:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com