On 2002-05-03 07:32, IML wrote:
for A1:A10, you could use
=COUNTIF(A1:A10,">"&5)-COUNTIF(A1:A10,">="&10)
On 2002-05-03 12:45, Chris Davison wrote:
On 2002-05-03 07:32, IML wrote:
for A1:A10, you could use
=COUNTIF(A1:A10,">"&5)-COUNTIF(A1:A10,">="&10)
Nice one IML,
Chris
On 2002-05-03 13:04, Chris Davison wrote:
sounds like my "indirects" where everything is inside quotes until the variables....
your "habit" still gives the same answer, I should add, just in case the reader thinks it's a no-no
On 2002-05-03 15:35, Chris Davison wrote:
Aladin,
interesting !
Any insight as to why Dutch or French syntaxes are different ?
rephrase : are both syntaxes acceptable to Excel, just that Netherlands and France prefer option (a) for some reason
or is Excel actually coded differently to take account of preferences in syntax by Netherland and France ?
.... tangent : is this just Excel ? Or is it Dutch and French computing in general ? What happens when France wants to launch a rocket to the International Space Station ? is there lots of "computer translations" ?
sorry...silly questions
interesting topic though
/board/images/smiles/icon_smile.gif