Question

Create a macro to be run as a function which halves the value of the passed argument​

Answer 1

Answer:

For example, =PositiveSum(7) or =PositiveSum(A4). In the first case, the number 7 is passed as an argument, and in the second case, the value of cell A4 is passed to the function. If a range is passed to the function, it is passed as a two-dimensional array of values; for example, =PositiveSum(A2:B5).

Explanation:

Answer 2

Explanation:

For example, =PositiveSum(7) or =PositiveSum(A4). In the first case, the number 7 is passed as an argument, and in the second case, the value of cell A4 is passed to the function. If a range is passed to the function, it is passed as a two-dimensional array of values; for example, =PositiveSum(A2:B5).