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...
You may hide it with IFERROR(), but since everything works on Excel 2010 and doesn't work on Excel 365 I'd check formulae carefully if they are correct for the modern Excel.
The issue seems to be with the "if" list function.
If I merely type figures into f34 and i34, then it doesn't matter which cell is left blank, there is no "#value!" notification in J34, and J34 will only display the currency symbol. For this test, F34 has not been "IF'd"!
If I merely type figures into f34 and i34, then it doesn't matter which cell is left blank, there is no "#value!" notification in J34, and J34 will only display the currency symbol. For this test, F34 has not been "IF'd"!
Price in formula shall be the number, not text. Result is formatted as pounds applying Accounting format.
Please check attached file.