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...
Thanks Sergei: The spreadsheet actually uses different cells to those I mentioned (though t it would be easier to explain). The Actual is this: Formulae in Cell J34 is =F34*I34.
Where I34 is the amount of product used and F34 is the price per unit of product.
F34 uses an "IF" based on C34 (=IFC34= "SAND", "£10", IF C34 ="CEMENT", "£5.00" etc) so if I put sand in C34 and 0.2 in I34, J34 will correctly show £20.
The issue is only occurs when I leave C34 blank (F34 is "automatic because of the IF function).
When I input a product into C34, but omit a quantity in I34, I just get the currency symbol in J34. This is what I am trying to achieve when C34 is left blank.
Where I34 is the amount of product used and F34 is the price per unit of product.
F34 uses an "IF" based on C34 (=IFC34= "SAND", "£10", IF C34 ="CEMENT", "£5.00" etc) so if I put sand in C34 and 0.2 in I34, J34 will correctly show £20.
The issue is only occurs when I leave C34 blank (F34 is "automatic because of the IF function).
When I input a product into C34, but omit a quantity in I34, I just get the currency symbol in J34. This is what I am trying to achieve when C34 is left blank.
I think the error is because of the symbol typed in the formula. Maybe you should use it under the format instead of the formula.