ExcelBanter - How to use Mround when calculating the following (B2+C2)/3

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to use Mround when calculating the following (B2+C2)/3 (https://www.excelbanter.com/excel-discussion-misc-queries/237615-how-use-mround-when-calculating-following-b2-c2-3-a.html)

Calvin

How to use Mround when calculating the following (B2+C2)/3

How to use MROUND when calculation on a cell that is alreay performing a
calculation such as below

(b2+c2)/3

joeu2004

How to use Mround when calculating the following (B2+C2)/3

"Calvin" wrote:
How to use MROUND when calculation on a cell that is
alreay performing a calculation such as below
(b2+c2)/3

Whadaya want to MROUND it to?

The following example MROUNDs to a multiple of 0.05:

=MROUND((b2+c2)/3, 0.05)

All times are GMT +1. The time now is 03:15 AM.