CEILING error

I believe there is an error in the error trapping logic in the built in CEILING function.

The lines..
if (d1 * d2 <= 0)
return FormulaErrorStrings invalid_arguments];

Incorrectly pulls an error if d1 is 0. I think the test should read.
if (d1 * d2 < 0)
i.e. if the signs are non zero and opposite.

Hi Brian,

Thank you for your interest in Syncfusion Products.

Could you please reproduce the issue in the following sample?. So that we could sort out the cause of the issue and provide you a solution soon.

http://files.syncfusion.com/support/Calculate.Windows/FormulaCeiling.zip

Regards,
Jisha

Oh come on guys! I've been very explicit as to what conditions cause the error and even shown you the correction to your source code.

Is it really necessary that provide a worked example?

Hi Brian,

COuld you please reproduce the issue in the sample given in the previous update?. So that we could analyze the issue here.


Regards,
Jisha