python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - let

Combining Ranges in Excel Functions with out helper cells

I am having difficulty figuring out how to get the correct data type evaluated as a single array passed to the first argument of the Small() in this function. My overall goal is (completely without th...
test-img

Dissymmetry

arrays

excel-formula

office365

let

Votes: 0

Answers: 1

Latest Answer

The reason your Let function fails is the (A1v,A2v) parameter to Small. That construct is the Union Operator for Ranges. A1v and A2v are arrays, not ranges. This can be seen in the Formula Evaluator...
test-img

chris neilsen

New to JavaScript - Let variable

I am learning JavaScript at the moment and please can someone explain to me why the following function would give the value of 9 and 10, as the let a = 10 is outside of the function block and I though...
test-img

LiBee

javascript

function

let

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs