hi, I have a cell that calculates its value from two other cells:
=C2*E1
This issue, is when the user enters a value in E1 that is not a valid number (i.e. enters German comma instead of an English decimal value).
I fix this, by adding in my ‘beforeChange’ a function that returns a valid number. e.g.:
2,3% --> 2.3%
But the hyperformular calculation shows the error: ‘#VALUE!’.
Where am i going wrong here plz?
When does the hyperformular calculate its value
Thank you for contacting us. Can you please share your current implementation? It would be easier to debug it this way.