Hi guys, I need some help with this,
Function powerarray(n, d)
Dim a()
ReDim a(1 To n, 1 To n)
( I am supposed to fill this part to get the desired result)
powerarray = a
End Function
Thank you in advance!
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
so basically powerarray(n,d) function generates n * n array that should contains the numbers as follow:
Function powerarray(n, d)
Dim a()
ReDim a(1 To n, 1 To n)
( I am supposed to fill this part to get the desired result)
powerarray = a
End Function
Thank you in advance!
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
so basically powerarray(n,d) function generates n * n array that should contains the numbers as follow:
- The initial offer is 20
- Each cell down should be divided by (1+d)
- Each cell down to the right should be multiplied by (1+d)
- powerarray (5,0,20) should generate the following outcome:
20,00(initialoffer) | ||||
16,67 (= 20/1,2) | 24,00 (= 20*1,2) | |||
13,89 (= 16,67/1,2) | 20,00 (= 24/1,2) | 28,80 (=24*1,2) | | |
11,57 (= 13,89/1,2) | 16,67 (=20/1,2) | 24,00(=28,8/1,2) | 34,56(=28,80*1,2) | |
9,65 (= 11,57/1,2) | 13,89 (= 16,67/1,2) | 20,00(=24/1,2) | 28,80(=34,56/1,2) | 41,47(=34,56*1,2) |