Forum Discussion
DIVIDE error ?
HI who can explain me DIVIDE(blank(),0,5) - return BLANK DIVIDE(0,blank(),5) - return 5 if (ISERROR( blank()/0),1,2) - Return 2 NOT ERROR if (ISERROR( 0/blank()),1,2) - Return 1 ERROR ...
There's no point in arguing.
If it is necessary to get a value other than BLANK as a result of division -
function is not suitable.
If a formula or procedure works incorrectly, it is usually fixed by the developers.
The recommendations to always use DIVIDE instead of IF is not 100% correct
So the performance is lost 😞 unfortunately
In addition, if divide(blank()/0,1) and divide(0/blank(),1) had given the same result, I would even agree with you, but unfortunately the results are different . Right ?
I disagree with you that it works incorrectly, but I agree with you that "arguing" would be a waste of time so have a great day! 😄