|re: Why does the * in the formula not multiply the 2 values together?|
It sort of does, but keep in mind that this is an array formula.
Select the cell with the formula and click on Tools...Formula Auditing...Evaluate Formula.
Then click on the Evaluate button and single-step through the formula.
See if you can figure out what's happening.