Hi,
I would like to create a User Defined Function (UDF) from a complex calculation in an excel sheet.
Illustrated as in the screeenshot below:
- Value D11 is calculated as a sum of D6-D10, which are in turn complex IF functions.
- Now I would like to have somthing like: customfunction(Input)=Value of cell D11
- I could translate this complex formula entirely in VBA and create a UDF from there directly... but this is rather cumbersome. Furthermore, I'm not a VBA expert (just now the basics).
- Better would be if I could create a UDF directly from this excel sheet. So I just tell excel to put the (input) in cell D2 and then return me the value D11.
Is there a way to achieve this?
Thx
I would like to create a User Defined Function (UDF) from a complex calculation in an excel sheet.
Illustrated as in the screeenshot below:
- Value D11 is calculated as a sum of D6-D10, which are in turn complex IF functions.
- Now I would like to have somthing like: customfunction(Input)=Value of cell D11
- I could translate this complex formula entirely in VBA and create a UDF from there directly... but this is rather cumbersome. Furthermore, I'm not a VBA expert (just now the basics).
- Better would be if I could create a UDF directly from this excel sheet. So I just tell excel to put the (input) in cell D2 and then return me the value D11.
Is there a way to achieve this?
Thx