Forum Discussion

JoshuaHughes1's avatar
JoshuaHughes1
Copper Contributor
Dec 04, 2024

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_Eekelen's avatar
    Riny_van_Eekelen
    Platinum 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

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor

    Wouldn't =ROUND(formula, 2) not work?

    Though it would round 0.495 to 0.50, not 0.49.

     

    • JoshuaHughes1's avatar
      JoshuaHughes1
      Copper Contributor

      Thank you. How do i add this in on top of the formulas that already exist?

Resources