Rounding

**dalewms2** · 10-20-2011, 07:53 PM

Can someone tell me how to round 2.3 to 3 using ROUND or MROUND in an array formula?

Thanks

**jeffreybrown** · 10-20-2011, 08:03 PM

Some particular reason you just don't use Roundup?

**dalewms2** · 10-21-2011, 01:41 PM

What I am working on requires me to use either ROUND or MROUND

**shg** · 10-21-2011, 02:15 PM

Homework ?

**dalewms2** · 10-21-2011, 05:50 PM

yes it is for homework

**daddylonglegs** · 10-21-2011, 06:16 PM

So are you rounding up to the next integer or something else? A single example doesn't demonstrate.

We won't do your homework for you, although we might be able to point you in the right direction, what have you tried so far?

**dalewms2** · 10-21-2011, 08:46 PM

Np. I figured it out. thanks

**jeffreybrown** · 10-21-2011, 09:00 PM

Maybe you could post your solution so others can learn what you have discovered?

Then you could mark the thread as solved so when people search for this particular fix they know a thread marked as solved could be the answer they are searching for...