Excel - Round Down to the nearest multiple

could anyone help me out with a formula similar to MROUND but that always
rounds down?  for example I have in cell A1 5.99 and I want to round this to
the nearest LOWER 1/8th.  So as where MROUND would give me 6.00, i need this
formula to round to 5.875.

any help is greatly appreciated!

  T. Valko replied to Xhawk57

Maybe this...

=FLOOR(A1,0.125)

--
Biff
Microsoft Excel MVP

  David Biddulph replied to T. Valko

But with the warning that with Biff's formula you will get a #NUM! error if A1
is negative.

=FLOOR(A1,0.125*SIGN(A1)) will work, if rounding "down" is regarded as
towards zero.
=IF(A1>0,FLOOR(A1,0.125),CEILING(A1,-0.125)) if "down" is towards minus
infinity.
--
David Biddulph

  Ron Rosenfeld replied to Xhawk57

If by "ROUNDDOWN" you mean round closer to zero, then:

=ROUNDDOWN(A1*8,0)/8

--ron

Win7 VirtualStore Weirdness with Excel 2002 and earlier Excel I thought I'd share a weird experience I had today in case it saves installer for it - - which registers it as an add-in for all installed versions of Excel - - and tested it. Fine in Windows 2000 in all installed versions of Excel. Boot to Windows XP, fine there too. Boot to Windows 7. Fine in Excel 2010, 2007, and 2003. But Excel 2002 and 2000 were still loading the old version of the add-in. I uninstalled the add-in, made sure it was gone, and reinstalled it. Same problem in Excel 2002 and earlier; still works fine in Excel 2003 and later. I opened the VB editor in Excel 2003 and in Excel 2002

Aggiornamento - Microsoft Risponde all’evoluzione delle Community Excel Cosa accade? Per informarvi che Microsoft comincerà presto a chiudere I newsgroup e a “transitare”, pian piano, se lo vorrete, il traffico sui Forum Microsoft. Perchè? Come ben sapete, i newsgroup sono esistiti per molti anni; il problema però è newsgroup. E’ possibile trovare informazioni su come installare e configurare il bridge qui: http: / / connect.microsoft.com / MicrosoftForums / Perchè i newsgroup verranno chiusi? Tutti i newsgroup pubblici verranno chiusi tra il la chiusura dei newsgroup, dove posso andare online per continuare le discussioni e ricevere supporto? Microsoft vi fornisce un’ampia scelta di forum, alcuni dei quali coprono lo stesso argomento od ottimale per continuare le discussioni online. Raccomandiamo quindi di cominciare con il http: / / social.answers.microsoft.com / Forums / it-IT / officeexcelit forum Vi invitiamo comunque a visitare i Forum Microsoft: http: / / www.microsoft.com / communities / forums / default.mspx Se ho domande, chi devo contattare? Se

32 bit DLL with 64 bit Excel 2010 Excel We have an app which creates large Excel workbooks. For example, one workbook has 1, 000 worksheets. In other cases there are fewer worksheets but the Excel file can be 80 MB or larger. Since this sometimes crashes Excel 2007 and 2003, I am considering using 64 bit Excel 2010. Would 64-bit Excel be more reliable with workbooks this size than 32-bit Excel? Is 32-bit Excel 2010 any more (or less) reliable with large workbooks than Excel

Erinnerung - Microsoft reagiert auf Evolution der Community Excel Microsoft Office betrachtet Community als Teil des neuen Office 2010 Wie Sie wissen ist das Jahr 2010 ein wichtiges Jahr f?r Microsoft. Die neue Office-Version kommt auf den Markt. Office 2010 soll Ihnen das Leben und Hersteller beim Kauf eines neuen PCs erwerben. Ihre gew?nschte Version ist auch direkt von Microsoft erh?ltlich. Durch eine neue Methode zur Softwarebereitstellung mit dem Namen ?Click-To-Run? gelingt individuell! Worum geht es? Diese Nachricht dient dem Zweck, Sie dar?ber zu informieren, dass Microsoft demn?chst die Newsgroups abstellen und die Nutzer auf die Microsoft Foren verweisen wird. Warum? Wie Sie vielleicht wissen, gibt es Newsgroups schon seit einigen Jahren doch ist die Nutzung der Microsoft Newsgroups seit Jahren stetig zur?ckgegangen, da Kunden und Teilnehmer vermehrt L?sungen in den

Alternate Rounding Up & Down of .50 in a column Excel Hello, I have not had any success in trying to do the following: I have up to the nearest whole number, etc. I appreciate any help with this. Thank you !! Excel Worksheet Discussions ESET Smart Security (1) Microsoft Excel (1) ROUNDDOWN (1) CEILING (1) ROUNDUP (1) Routine (1) MROUND (1) ISEVEN (1) Hi Try = IF(MOD(ROW(), 2)<> 0, ROUNDUP(A1, 0 ROUNDDOWN(A1, 0)) Depending upon whether the first row you are trying to Roundup is Odd