|My guess is that one (or both) of the cells you are trying to multiply contains text or something that Excel does not recognize as a number.|
You can review the Help file on the #VALUE! error for some troubleshooting tips, or you could try this:
A cell can sometimes get stuck in Text mode and regardless of how you try to format it, it won't change. The following steps will usually resolve that issue.
Select an empty cell
Ctrl-C to copy
Select H3 or J3 or both
Right-click one of the selected cells and choose Paste Special
Click the Add button and then OK.
Excel will try to Add 0 (zero) to the contents of the cell, typically forcing it to become a number.
Hope that helps.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.