McBee83Copper ContributorNov 26, 2019Round up Formula help Hi, I have been using this formula for cost a calculation but there is an error i would like to correct. =IF(MOD(100,C13)>1,ROUNDUP(C13*2,-1)-1,(C13-1)) Error: if the original value is 50 the answ...Show More
PReaganBronze ContributorNov 26, 2019Hello McBee83, Your formula was very close to being correct. The corrections are marked in red:=IF(MOD(C13,100)>1,ROUNDUP(C13*2,-1)-1,(C13-1))
