The formulas that you’re used to using in Excel are available to you in VBA as well. In VBA they’re called “Worksheet functions” so see the definition there. See also “Operators“.
Macros coverage from the financial modelling course
You’re looking at the macros glossary from our course material covering the use of macros in Excel financial modelling.