Hello,
What VBA Code should I use to multiply two excel cells separated by commas and return the dot product?
Ex. Cell A1 = 1,0.512,2
Cell B1 = 25,3,1
Cell C1 = 1*25+0.512*3+2*1
Also, what VBA code should I use to add the numbers in one cell?
Ex. Cell C2 = 25+3+1
Thank you