Cell value displays error( #value0,#div\0) after calculating the formula

Tags: #<Tag:0x00007f8b2a0c9128>
#1

i want to rectify the error #value0,#div\0.refer this for example,
http://jsfiddle.net/RishabhRanjanKesarwani/k4cdp9b3/160/
i know y this errors came here.but can i have any possibilities neglate that.

#2

Hi @user123

What you would like to get there instead of the error? If the user won’t be able to change the value of C3 and D3 then you could just one a custom renderer. However, if you want to allow this action you can consider using beforeChange hook. Then you’ll be able to change D3 to any value of your choice.

#3

i want to get 0 instead of the error.please give some example jsfiddle.

#4

You should be able to get the desired result by switching to

‘=IF(D3=0;0; C3/D3)’,

but it has a bug as well.
As the formulas are really buggy (they’re still in alpha stage of development and surely will be till the end of 2018) I highly encourage to replace them with native JS and our API.

Here’s a code http://jsfiddle.net/1onhsptq/ (starts in line 67)

#5

can i have any possibilities to use iserror(),iferror() functions in handsobntable.

#6

I am sorry but it is not possible of the bug that I have mentioned above http://jsfiddle.net/1u46eyf3/. When you check a condition for zero you always get an error.

#7

ok thank u @aleksandra_budnik

#8

You’re welcome @user123

#9

if i do the operation like ‘=IF(D3=0;0; C3/D3)’, for this value zero,it shows error “#value!” can i have any options to put the answer as zero.

#10

That is correct. That is the issue that I have mentioned before. The formula should return 0 but it returns the C3/D3. This issue has been reported, however, as we are slowly working on a new formula engine I do not know when we’ll be able to represent a bugless version of the formula support.

#11

ok @aleksandra_budnik

#12

@user123
I have posted the workaround for this several times in this forum. See e.g. Cell value displays '#VALUE!'

#13

Thank you for posting @jon

I hope that one day I’ll be able to let you know that the Formula support is done and works fine

#14

@aleksandra_budnik
:slight_smile:
As I have said before, I made the very original, free, RuleJS formulas in HoT work reliably (with some code changes) years ago, and have stuck with that ever since on the old version of HoT!

#15

how to do this =IF(D3 = 0, 0, C3 / IF(D3 = 0, 1, D3)) for null value.

#16