I’ve seen lots of stuff about bankers rounding which just lead me down a rabbit hole I really didn’t want to go down.

All I want is to figure out either a good formula that does ‘Bankers Rounding’ or ‘Half Way Even Rounding’

It seems like such an easy thing to do on paper, the rules are really clear, but I can’t for the life of me find a reliable formula to do it without getting into what for me is incredibly high level mathematics that I’m just not able to understand at all.

I’ve tried a few formulas already and for some unknown reason I can’t get them to work as expected.

I’m trying to round decimal currency, so for example 1.755 would round UP to 1.76 and 1.765 would round DOWN to 1.76 as in both cases 1.7(6) is the nearest EVEN digit.

Does anyone here know of a fairly simple formula that I can use for this?

I found a spreadsheet online that had a VBA formula, but it was just totally beyond me how I could import that into my libreoffice calc system. They always assume you know much more about what you’re doing than you actually do, so I ended up faced with loads of different macro VBA editing formatting inserting windows that had multiple possible choices, none of which made any sense to me at all. So I just gave up on that route!