The differences seem to be: * You can write it in one language (excel formula language) * The language is simpler and known by almost all users, while Javascr

The differences seem to be: * You can write it in one language (excel formula language) * The language is simpler and known by almost all users, while Javascript and VBA are only used by a tiny proportion of users. * The language is more secure (i.e. you can't execute arbitrary code, access files, call DLLs etc) * Because of the above, users don't need any security permissions / get warnings when running it. * Because they are standard excel formulas, you get OOTB support for other excel features such as dynamic array formulas and access to the full catalogue of worksheet functions (even in VBA, Application.Worksheet only had access to a few basic excel workbook functions, so if you wanted to do a Xlookup for example you are implementing it yourself with arrays and loops)