Note that further math-related Excel functions are also provided in the Excel Statistical Functions and Excel Engineering Functions categories. The FIX function in MS excel returns the Integer part of a number. This example uses the Sin method of the Math class to return the sine of an angle.
Some of the important lookup functions are VLOOKUP HLOOKUP INDEX and MATCH.
VBA will add the two values for you and store the answer into the cell B1. Note that further math-related Excel functions are also provided in the Excel Statistical Functions and Excel Engineering Functions categories. This example uses the Sin method of the Math class to return the sine of an angle. Just like in ordinary mathematics the plus symbol is used to add up.