How to Create a Function on VBA with the following instruction:

Return on Capital employed(ROCE) (Net Income -Taxes -Interest (EBIT))/(((Beg Assets -Beg Cur. Liab.)+(End Assets-End Cur. Liab.)2)

When creating the ROCE function define two variables one for EBIT and One for Averag Assets.

Add a line of code to calculate EBIT and store it in the EBIT varaible

Add another line of code to calculate Average assets and store in the Average Assets variable

Then add a line of code to calculate ROCE by dividing EBIT by Average Assets.