I need help with a Function

X

XL 411

Here is what I got:

F24 = 64
F25 = 12

on cell F26 I got the function =MROUND(F24, F25) which gives me 60.
Basically the formula is rounding 64 to the nearest multiple of 12, which
it"s 60. But what I want is for a formula to roundup to the nearest multiple
of 12. In other words I want the outcome to be 72. Can anybody out there help
me with this issue. If you have an answer please send me an e-mail to
(e-mail address removed). Thank you for the time
 
D

David Biddulph

=CEILING(F24, F25)

Note: if you ask a question in a newsgroup, you get an answer not by email
but in the newsgroup, so that the answer can hopefully be of benefit to
others (and so that other folk can correct an answer if it's wrong!).
 
R

Rick Rothstein \(MVP - VB\)

Assuming you do not want to round up F24's value if it is already an exact
multiple of the value in F25...

=IF(MOD(F24,F25)=0,F24,MROUND(F24+F25, F25))

Rick
 

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

rounding a number up to a certain ending digit 6
MROUND Help 1
how do i drag a formula 3
Need Help with Macro Security 1
Excel - Wich Function should I use? 1
Problem with SET & REF function 0
Need Help with a VBA subroutine 0
VBA - (re-) Set a Table Style 2

Top