modificate array cells

[adriana25]

hi, i have an a array formula which include the cells A1 until D1; but i need the formula until C1, in the D1 i want an onother formula, but i can't do this.. it gives to me an error message" impossible change a part of array"

haw can i modificate ? Thank you

 

[pgc01]

Hi

Select A1:D1 and delete the formula.

Select A1:C1, reenter the formula in the formula bar and confirm it with CTRL-SHIFT-ENTER.

Enter the new formula in D1.