Forum Discussion
How do I change "#VALUE!' or at least stop it from showing?
I've set up an Invoice template in XL. In the template I can a select a "product" in a cell (e.g C1), and the price of the product per unit is automatically shown in another cell (e.g F1). Finally in...
I think you should check the below error definition site because as per microsoft #value happens when : "There's something wrong with the way your formula is typed. Or, there's something wrong with the cells you are referencing."
https://support.microsoft.com/en-us/office/how-to-correct-a-value-error-15e1b616-fbf2-4147-9c0b-0a11a20e409e
https://support.microsoft.com/en-us/office/how-to-correct-a-value-error-15e1b616-fbf2-4147-9c0b-0a11a20e409e
jitinm Yes but No! It always used to be (with 2010), if C1 was left Blank, then the currency symbol only would display (no value) in J1. Not anymore, and this is what I am trying to achieve.
Just to reiterate, the issue doesn't exist in there is "input" at C1.
I would think there would be a conditional formatting resolution for this?
At the moment I am on a "work around" by using B1 as a cell rather than C1 (B1 has text!). I don't obtain any "#VALUE!" messages in J1 when I do this, although one would think there would be!.
