Forum Discussion
JoshuaHughes1
Dec 04, 2024Copper Contributor
Rounding up/down half a pence on excel
Good afternoon,
I am needing to round up/down certain columns whilst keeping the formula.
I need columns E & F to round up or down depending on the amount, from rows 5,6 7, 8 and 9.
Due to the % and the amount some of the answers will include .5 of a pence. I need something that would do the below.
5245.505, the formula will round it to 5245.51.
5245.495, the formula will round it to 5245.49.
Any help appreciated. (I left an example in the sheet to show)
Thank you
Joshua
- Riny_van_EekelenPlatinum Contributor
Select the cell with the formula and insert ROUND( after the = sign and ,2) at the end. Press enter.
By the way, I notice you have an odd formula in one of the sheets like =SUM(cell/1*percentage)
That can be simplified to =cell*percentage.
Another one is =SUM(cell1 + cell2). Than can be =cell1 + cell2
- JoshuaHughes1Copper Contributor
Thank you, thats worked and helped alot!
- Riny_van_EekelenPlatinum Contributor
Wouldn't =ROUND(formula, 2) not work?
Though it would round 0.495 to 0.50, not 0.49.
- JoshuaHughes1Copper Contributor
Thank you. How do i add this in on top of the formulas that already exist?