This post explains how you can make your own functions in Excel without VBA. Suppose you have a spreadsheet like this: Ugh! That is an ugly formula! Wouldn’t it be nicer if we could write something like =getCity(A2)? Of course, we could make a user-defined function (UDF) with VBA. VBA is powerful enough to create functions, […]
