ROUNDUP help

[Chewiesarmy]

Hello,

I did look for this, but could not finds an old post.

I have a cell (I4) that includes =ROUNDUP(H4/C4,0). I want any number in H4, which has the formula (F4-G4), greater than zero to round to the next whole number, EX: .01 rounds to 1, 2.5 rounds to 3 5.9 rounds to 6, etc. Issue is...when the H4's value is 0, it rounds it to 1. I have tried IF statements, IF (H4=0, 0, h4/c4), which kind of worked accept when H4 was 0, it would then round to 1. Actually, H4 shows as 0.0, but I even tried to account for this in the formulas.

So, I am subtracting G4 from F4 to get a net. This is happening in H4. Then, I want I4 to round the value of H4 to the next whole number, accept anything less than or equal to 0, stays 0.

How do I get it that if H4's value is zero, then I4 will not round it to 1, and keep it 0?

I must be using ROUNDUP incorrectly?

Thanks!

[CK76]

That's likely caused by floating point error. What appears to be 0 isn't truly a 0 and has very small decimal value.

May be try...
=ROUNDUP(IF(Round(H4,4)=0,0,h4/c4),0)