If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"--" 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! |
#2
|
|||
|
|||
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 atyahoodotcom ---- "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! |
#3
|
|||
|
|||
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 atyahoodotcom ---- |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formula to Count and Return Most common Value in a Dynamic Named Range | Tinä | General Discussion | 1 | October 23rd, 2004 11:26 PM |
Formula to Count and Return Most common Value in a Dynamic Named Range | Tinä | General Discussion | 1 | October 23rd, 2004 08:51 PM |
Excel Formula | yuki | Worksheet Functions | 7 | September 28th, 2004 02:40 AM |
Add to formula | Pat | Worksheet Functions | 16 | September 24th, 2004 03:38 PM |
Alternative formula to HLookup | Bernie Deitrick | Worksheet Functions | 0 | March 26th, 2004 12:53 PM |