Find The formula between Numbers-CodePudding

I want to find the relational Formula between X and Z this below :

X                               Z
8949430070120254001         24307547
8949430070120254019         64939975
8949430070120254027         62651206
8949430070120254035         42288628
8949430070120254043         09065578

the point is how to find the formula for the number that is Z from the number X

CodePudding user response：

Assuming you mean columns X and Z in a workbook, and that

number that is Z from the number X

means X minus Z, this can be done without vba.

In Cell AA1, enter the formula =X1-Z1

If the 'relational formula' is more complex than the difference, you're going to have to explain that more clearly so we can answer the question.

CodePudding user response：

This is more of an algebra question: do some research into "Finding a Function of a line" - should point you in the correct direction.