MRound Formula

L

LauraLee

I'm trying to add the Mround to a cell that already has an exisiting formual
(i.e. a3*a4). How do I create the circular reference so that it will round
the figure to the nearest 1,000. Thanks
 
G

Gord Dibben

=MROUND(A3*A4,1000)

Note: MROUND function requires the Analysis Toolpak to be enabled in
Tools>Add-ins


Gord Dibben MS Excel MVP
 
S

Shane Devenshire

Hi,

MROUND is a built-in function in 2007 so you don't need to attach the ATP if
you are using that version.

I think ROUND would be the most common answer for this example.
 

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

Inserting MROUND into existing data 1
MROUND error showing 7
Rounding problems 6
Round Function 5
Excel: Round formula up in $5. increments =+(M4*1.1)+M4 5
Round up to next .5 5
Round Down to the nearest multiple 2
Want To Shrink Formula 1

Top