Home |
Search |
Today's Posts |
#1
|
|||
|
|||
shortcut to a function?
I have noticed in a few posts now that -- is used in some of the solutions to
the questions asked eg =COUNT(--(ROW(1:360)0)) My question is, what does the -- mean? |
#2
|
|||
|
|||
See http://www.xldynamic.com/source/xld....CT.html#format for a
detailed explanation. Odd formula you showed, the 0 doesn't seem to do anything. -- HTH Bob Phillips "SusanR" wrote in message ... I have noticed in a few posts now that -- is used in some of the solutions to the questions asked eg =COUNT(--(ROW(1:360)0)) My question is, what does the -- mean? |
#3
|
|||
|
|||
Bob,
Without the 0 the formula gives 1 as a result, no matter wether it has 1:360 or 1:36. I would say in all cases it does nothing, but what causes the 1 as a result? Jack Sons The Netherlands "Bob Phillips" schreef in bericht ... See http://www.xldynamic.com/source/xld....CT.html#format for a detailed explanation. Odd formula you showed, the 0 doesn't seem to do anything. -- HTH Bob Phillips "SusanR" wrote in message ... I have noticed in a few posts now that -- is used in some of the solutions to the questions asked eg =COUNT(--(ROW(1:360)0)) My question is, what does the -- mean? |
#4
|
|||
|
|||
The link you gave explained the question thanks.
The formula itself was just an example taken from another post elsewhere in the forum, it wasn't necessarily a correct formula. "Bob Phillips" wrote: See http://www.xldynamic.com/source/xld....CT.html#format for a detailed explanation. Odd formula you showed, the 0 doesn't seem to do anything. -- HTH Bob Phillips "SusanR" wrote in message ... I have noticed in a few posts now that -- is used in some of the solutions to the questions asked eg =COUNT(--(ROW(1:360)0)) My question is, what does the -- mean? |
#5
|
|||
|
|||
It's an array formula Jack, and it retunes 360 with or without 0 as long as
you array enter it. -- HTH Bob Phillips "Jack Sons" wrote in message ... Bob, Without the 0 the formula gives 1 as a result, no matter wether it has 1:360 or 1:36. I would say in all cases it does nothing, but what causes the 1 as a result? Jack Sons The Netherlands "Bob Phillips" schreef in bericht ... See http://www.xldynamic.com/source/xld....CT.html#format for a detailed explanation. Odd formula you showed, the 0 doesn't seem to do anything. -- HTH Bob Phillips "SusanR" wrote in message ... I have noticed in a few posts now that -- is used in some of the solutions to the questions asked eg =COUNT(--(ROW(1:360)0)) My question is, what does the -- mean? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions | |||
Assign Specific Function to Shortcut | Excel Worksheet Functions |