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

  • Thread starter Thread starter Calvin
  • Start date Start date
C

Calvin

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

(b2+c2)/3
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MROUND 4
MROUND time 2
MRound 2
Round Down to the nearest multiple 2
Why doesn't MROUND work? 2
Logically Calculating Multiple Fields 5
excel formula for markup and profit margin 3
Array follow up 1

Back
Top