rounding issue

[#1]

4.255, when round it , i become 4.25instead of 4.26. 

i want it to be 4.26,which should be correct in my understanding

[thomas_skariah]

Hi Max,

If the value is 4.255 then it would be 4.25 and if it is 4.256 then it would be 4.26.

Regards,

Tom

[#3]

what does it mean when decimal is 5 , it would be ignored?

[#4]

what does it mean when decimal is 5 , it would be ignored?

[Sokkorn]

Hi,

Here should work =Round(4.255,0.01) (reture 4.26)

Regards,

Sokkorn

[#6]

above method is not working

the overall score is caculated based on the teacherquality*0.8+ overallimpression*0.2

[tresesco]

yes, qv shows some weird(at least i can't explain it yet) results.

Look, first two are not as expected.

[Sokkorn]

Did you set any Number format in Format tab?

[er_mohit]

have you tried with ceil function

ceil(1.255,0.01)

[#10]

when fixed to is "3" it comes out 4.255,  when fixed to"2"  it is 4.25.    but i want it to be 4.26   according my knowledge on round()