Hi Markus
one way: you can use User Defined Functions (UDFs) for this. In VBA
create a macro:
Public Function GET_OUR_VALUE (net_profits as double) as double
' your code...
End Function

Frank

Markus Wildgruber wrote:
Hi!

We make software for financial accounting and want to integrate some
of that functionality in MS Excel.
Is it possible to add custom formulas that can be used in cell
expressions?

As the user now is able to use the AVERAGE-function he should be able
to use our custom formulas e.g. GET_OUR_VALUE( 'NET PROFITS' ):
=AVERAGE(A1:A4)
=GET_OUR_VALUE( 'NET PROFITS' )

How can we achieve this?

TIA,

Markus