# Rounding Up an Extra Number when .9 or higher

Microsoft Excel 2003 (full product)
May 20, 2010 at 04:58:57
Specs: Windows XP
 Hello,I'm working on a Kanban system and I'm trying to edit a cell in Excel where if the number has a decimal of .9 or higher (like 1.92 or 2.97) that it not only rounds up, but it also adds one. Like 1.92 would become 3. But ONLY if the result is has a .9 or higher. So if it's 1.56 then it should just round up to 2. It would be really awesome if anyone could help!

See More: Rounding Up an Extra Number when .9 or higher

#1
May 20, 2010 at 05:58:01
 How is the number getting into the cell?Assuming it's the result of a formula, I'd try this.I'll use =A1+B1 as the "base" formula for getting the number in the cell.=IF((A1+B1)-INT(A1+B1)>=0.9,ROUND(A1+B1,0)+1,ROUND(A1+B1,0))P.S. you didn't say what should happen if the decimal is < 0.5, so I don't know if you always want to ROUNDUP or just ROUND the result.I assumed ROUND.

Report •

#2
May 20, 2010 at 06:14:58
 That's PERFECT! It's working exactly as I wanted it to. Sorry, I forgot to mention it should be ROUNDUP but I edited it.Thank you SO MUCH!

Report •
Related Solutions