DERIVF can be nested to compute partial derivatives of any order:
Consider the partial derivative:
We compute the partial derivative of cos(xy) at (π,π) by nesting DERIVF and compare the result with the analytical value shown in B3 below:
| A | |
| 1 | =COS(X1*Y1) |
| 2 | =DERIVF(B1,X1,PI()) |
| 3 | =DERIVF(B2,Y1,PI()) |
| A | B | |
| 1 | 1 | |
| 2 | 0 | |
| 3 | 9.3394486379 | 9.3394486379 |
