BROUND in Excel

Question

I got one excel file with BROUND function in it. Does anybody know what it does?

Answer 1

Hi jo1ri1, yes you can call BROUND in that workbook and if you need it in another workbook, you just need to copy that VBA into the other workbook to be able to call that function

You call that function like any other Excel function in a cell:

=BROUND( . . .. )

Answer 2

Hello DaveM121,

thx, looks like VB, found a module that has some kind of a macro. Can I use this formula inside this workbook?

Answer 3

That is not a build in function, see

https://support.office.com/en-us/article/round-...

It might be possible that the file contains macros and BROUND is a UDF.

Or it is a name. Or it is a function that is placed in an AddIn. Or...

If you need further help please upload your file (maybe with anonymous data) on an online file hoster like www.dropbox.com and post the download link here.

A macro to anonymize data in selected cells can be downloaded here:

https://www.dropbox.com/s/rkfxuh85j5wyj9y/modAn...

Andreas.

Answer 4

Hi jo1ri1, that is not an Excel function, it must be written in VBA on that workbook by the person who created it . . .

That name is normally used to declare a Bankers Round . . .

Open the Excel document

Press Alt + F11 to open the VB Editor

At the top left, double click each of the sheets and ThisWorkbook until you find the function called BROUND

Answer 5

Sounds like "Banker's Rounding" custom UDF like here, possibly:

https://www.pcreview.co.uk/threads/bankers-roun...

Note: This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.