<?php
namespace PhpOffice\PhpSpreadsheet\Calculation\MathTrig;
use PhpOffice\PhpSpreadsheet\Calculation\Functions;
use PhpOffice\PhpSpreadsheet\Calculation\MathTrig;
class Mround
{
public static function funcMround($number, $multiple)
{
$number = Functions::flattenSingleValue($number);
$number = $number ?? 0;
$multiple = Functions::flattenSingleValue($multiple);
if ((is_numeric($number)) && (is_numeric($multiple))) {
if ($number == 0 || $multiple == 0) {
return 0;
}
if ((MathTrig::SIGN($number)) == (MathTrig::SIGN($multiple))) {
$multiplier = 1 / $multiple;
return round($number * $multiplier) / $multiplier;
}
return Functions::NAN();
}
return Functions::VALUE();
}
}