Rounddown problem

robert92 · Mar 7, 2016

Hello again. I have this worksheet. Where is red should be 5.0 but there's nothing (0.0). I think formula's a good one...if i'm wrong, correct me.

Thanks

NBVC · Mar 7, 2016

That is caused by Excel Floating Point arithmetic which may cause inaccurate results... see https://support.microsoft.com/en-us/kb/78113

Try Rounding the result of the inner function to one decimal to match your table entries)

=ROUNDDOWN(ROUND((SUM($H19:AK19)+$E19-SUM($H20:AJ20)),1)/$B20,0)*$B20

robert92 · Mar 9, 2016

NBVC said:
That is caused by Excel Floating Point arithmetic which may cause inaccurate results... see https://support.microsoft.com/en-us/kb/78113

Try Rounding the result of the inner function to one decimal to match your table entries)

=ROUNDDOWN(ROUND((SUM($H19:AK19)+$E19-SUM($H20:AJ20)),1)/$B20,0)*$B20

Thanks, It work perfect!!!

Rounddown problem

robert92

New member

Attachments

NBVC

Super Moderator

robert92

New member