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!

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.

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!

Ask Your Question

Weekly Poll

Do you think Amazon should have bought Whole Foods?

Discuss in The Lounge

Poll History