I once wrote something like this for a Bill-Of-Material application. This is how I did it.

It contains a table with products (end products, components, etc) and a table with relations...

So, a simple example focused on just one function (IF), IF(ColumnA = "Text1", 1, 0) + IF(ColumnB = "Text2", 1, 0) would be parsed on the + and then each...

Hi Calvin,

First of all, thanks for the input. It is indeed the parsing which becomes quite complicated. I once created a vb-class which could handle expressions with simple one variable...

I just want the user to be able to write simple xls-look-alike functions which are stored in one column in a table (through an asp.net front end). In the end,...