explicite or optional optionalarguments in WSF

[tim201110]

Hi,
i allways see here people put in all the arguments into function
i am curious why is TRUE or FALSE exept of 1 or 0 or default?
secondally some function require all arguments.
Why?

[shg]

It depends on the coding of the function's signature; arguments declared as Optional need not be included.

For the OFFSET function, Help says rows and columns are required arguments, but your example in B1 shows otherwise. Ditto for the day argument in the DATE function in E1.

For the MATCH function in D1, the matchtype argument is optional.

For the EOMONTH Function is F1, the months argument is required.

For arguments declared as Boolean but passed as numbers, zero is coerced to False and any non-zero number is coerced to True.

[tim201110]

Did you really mean it? Sorry
My question was why?

[shg]

Mean what?

Why what?

[tim201110]

1 difference between "digit (0 or 1)" and "" (empty)?
2 EOMONTH does not undestand "", but DATE does
Different programmers wrote code for these functions? They did not communicate?

[shg]

My objective was to explain, not rationalize.

[tim201110]

Thanks,
i suspected my question was rhetoric
the same in a file
is this a excel bug or a feature?

[shg]

What is the formula supposed to do, Tim?

[tim201110]

it sums numbers in even rows
if to remove N(, it stops to do it

[shg]

That's a behavior I can't explain. It has to do with de-referencing a range; I've seen an explanation by Aladin on MrE, but didn't manage to internalize it.

[tim201110]

Shg, could you give a link to this explanation?
thanks

[shg]

I don't have one handy. You might search MrE for dereference, dereferencing, and deferencing (a typo).

I did see ExcelXOR's blog post at https://excelxor.com/tag/dereference/

[tim201110]

Thank you one more time

[shg]

You're welcome.