Articles

multiplying by a constant, cell says value!

May 20, 2011 at 04:37:52
Specs: Windows 7

I am trying to multiply a column of numbers by a constant in Excel. I have put in the formula, and it comes up saying #value! rather than the figure.
I have tried it in a new blank excel sheet with made up numbers, and can get it to work, using =a1*$c$1.
When I try it on the page I want to actually complete, I need to use =h3*$j$3, but this one comes up #value! .
Help please!

See More: multiplying by a constant, cell says value!

Report •


#1
May 20, 2011 at 07:20:21

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.


Report •
Related Solutions


Ask Question