my user defined function doesn'work

**an61sa** · 05-21-2012, 03:08 AM

dear all,
I tried to create a User Defined function to calculate a price with some if nested and
the item keep from tables.

Could you help me ?
many thanks

I have excel 2003.

here the code and the sheet in simplified way as attachment

Please Login or Register  to view this content.

[/SIZE]

**an61sa** · 05-21-2012, 03:16 AM

Dear all,
Sorry, I see some errors in the code
that I modified in this way

Please Login or Register  to view this content.

**WHER** · 05-21-2012, 04:10 AM

There were some duplicate Dim statements in the UDF, and a typing error in the formula in cell A1.
This modified version produces a result, check if it's mathematically correct.