Forum Discussion

Copper Contributor

Jun 04, 2022

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...

Formulas and Functions

Copper Contributor

Jun 04, 2022

Which symbol? (Please see my Reply to Sergei)

jitinm

Iron Contributor

Jun 04, 2022

Pound "£" :- (=IFC34= "SAND", "£10", IF C34 ="CEMENT", "£5.00" etc) . I tried to replicate it in the excel and it is showing #value error. When I removed it worked just fine. Instead you should use currency symbol in the format cell

jitinm
Iron Contributor
Jun 04, 2022
jitinm