How to get round values from excel sheet using php?

[jacksantho]

Hi,

This is my excel sheet
B
1. marks
2. 50.65

my php code is:

$marks  = round($Worksheet->Cells->Item($i,2),0);
           echo $marks;

output is:
50 (wrong output)

I need the output: 51 . How to check this using php coding? Thanks in advance

[karthik_ppts]

Try this

$mark=$Worksheet->Cells->Item($i,2);
    $marks = round($mark);
    echo $marks;

[jacksantho]

What you told ? I tried this before itself.My value is not getting it round off.

[HemantPHP]

"Karthik_pranas" is right it's working fine you need to just round() value.. I trying this my self..

[jacksantho]

Hi,
I am getting values from my excel (ie) 50.65. calling in the php ...round is not working.

[almostbob]

at least it means your host is using php5.3 (>=5.27 anyway) the handling of round() was altered to comply with some standard
http://php.net/manual/en/function.round.php

echo round($Worksheet->Cells->Item($i,2),0,PHP_ROUND_HALF_UP);

'standards' is not intuituve, behaves WRONG