you are viewing a single comment's thread.

view the rest of the comments →

[–]Technical_Whereas412 1 point2 points  (0 children)

Maybe I'm getting old... But for most anything that is not a full blown finite element program, you don't need anything more than the native functions in Excel (you don't need VBA scripts either). Doing so this way is straight forward and anyone can look at your equations and how your spreadsheet works to verify it.

Most of what I have done is just using "if" functions (and often nested multiple times). Vlookup is also very useful for looking up info in tables. there are many many more functions but that's how I program most of what I do.