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 th...
Riny_van_Eekelen
Dec 04, 2024Platinum 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
JoshuaHughes1
Dec 05, 2024Copper Contributor
Thank you, thats worked and helped alot!