Thread: How to use Mround when calculating the following (B2+C2)/3
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joeu2004 joeu2004 is offline
external usenet poster
  
Posts: 2,059
Default 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)
Reply With QuoteReply With Quote