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

C

Calvin

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

(b2+c2)/3
 
J

JoeU2004

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

Whadaya want to MROUND it to?

The following example MROUNDs to a multiple of 0.05:

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