[SOLVED]Using another sheet like function

Phobosd What you describe is achieved by User Defined Functions (requires VBA programming) or by what is often referred to as "helper" columns, where each column contains a formula that solves part of the problem. The attached workbook contains a very simple example of both. You only need to imagine that the three calculations in this example are in fact the "hard calculations too complicated to be described with one formula" that you mentioned.