Excel Roundup Issue

Discussion in 'Software' started by mjollnir, Mar 19, 2020.

  1. mjollnir

    mjollnir Private E-2

    Hello,

    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 to 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!
     
  2. foogoo

    foogoo Major "foogoo" Geek

    baklogic likes this.

MajorGeeks.Com Menu

Downloads All In One Tweaks \ Android \ Anti-Malware \ Anti-Virus \ Appearance \ Backup \ Browsers \ CD\DVD\Blu-Ray \ Covert Ops \ Drive Utilities \ Drivers \ Graphics \ Internet Tools \ Multimedia \ Networking \ Office Tools \ PC Games \ System Tools \ Mac/Apple/Ipad Downloads

Other News: Top Downloads \ News (Tech) \ Off Base (Other Websites News) \ Way Off Base (Offbeat Stories and Pics)

Social: Facebook \ YouTube \ Twitter \ Tumblr \ Pintrest \ RSS Feeds