Forum Discussion
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...
Wouldn't =ROUND(formula, 2) not work?
Though it would round 0.495 to 0.50, not 0.49.
Thank you. How do i add this in on top of the formulas that already exist?