VBA Code for Multiplying/Adding two Excel Cells

[ameya]

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

 

[ameya]

So far, I was thinking
Public Function NewMult(TRange As Variant, SRange As Variant)
'Sheets("Calculations").Select
For i=1 to len(TRange)
NewMult=TRange(i) * SRange(i)
Next Cell
End Function