Question

Change the value in D6 to be 1033.5 What is the new value in D18?

Answer 1

D6 = 1033.5

Continuing series towards 18, we can assure of some observations

D(18) = D(24-6) = 24th value of D - 6th value of D = 1033.29 - 1033.5 = -0.21

Answer 2

If we change the value in cell D6 to 1033.5 and take D24 to be 1033.29, then the new value in cell D18 would be the difference between D24 and D6. Thus, the calculation would be D18 = D24 - D6, which results in a new value of -0.21 in cell D18.

If we take D24 = 1033.29 and change the value in D6 to be 1033.5, then the new value in D18 would be:

D18 = D24 - D6 = 1033.29 - 1033.5 = -0.21

Therefore, the new value in D18 would be -0.21.

#SPJ3