Select cell A3 to add that cell reference to the formula after the division sign. So if you want to multiply 10 by 5 in VBA you could do it like this. The QUOTIENT function - Returns only return the integer portion whole number only of a division operation.
In programing languages the multiplication sign is the asterisk.
Multiply Values in Excel. In the last lesson you used variables to add and subtract with Excel VBA code. Division in Excel is one of the simplest functions you can perform. For example the formula PRODUCTA2A4A1512E3E5150G4H4J6 multiplies two single cells A2 and G4 two numbers 12 and 150 and three ranges A4A15 E3E5 and H4J6.