+ Reply to Thread
Results 1 to 3 of 3

Greatest multiple>x

  1. 11-30-2017, 04:58 PM #1
    businpro
    businpro is offline
    Registered User
    Join Date
    11-08-2017
    Location
    miami, florida
    MS-Off Ver
    2010
    Posts
    35

    Greatest multiple>x

    How do i enter in a formula "greatest multiple of A which is smaller than B'
    Reply With QuoteRegister To Reply
  2. 11-30-2017, 05:06 PM #2
    daddylonglegs
    daddylonglegs is offline
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Greatest multiple>x

    What sort of numbers are we talking about? For integers try

    =FLOOR(B1-1,A1)
    Audere est facere
    Reply With QuoteRegister To Reply
  3. 11-30-2017, 06:21 PM #3
    businpro
    businpro is offline
    Registered User
    Join Date
    11-08-2017
    Location
    miami, florida
    MS-Off Ver
    2010
    Posts
    35

    Re: Greatest multiple>x

    thanks that worked. floor(B,A)
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Comparing columns for greatest value across multiple columns
    By gorgothnia in forum Excel General
    Replies: 2
    Last Post: 03-15-2013, 05:25 PM
  2. [SOLVED] Excel 2007 : Multiple Occurrences, lookup to find greatest value
    By coxb in forum Excel General
    Replies: 6
    Last Post: 05-12-2012, 11:40 AM
  3. Is the value of the cell the greatest value or the second greatest or....
    By Ipinho100 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-27-2011, 12:01 PM
  4. Find greatest multiple of 50 which is less than X
    By psuce in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-14-2011, 03:41 PM
  5. Greatest Value Formula
    By Andyb43 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-10-2011, 11:25 AM
  6. Our Greatest Achievement
    By D_Rennie in forum The Water Cooler
    Replies: 11
    Last Post: 08-02-2009, 09:26 PM
  7. Greatest to smallest
    By Dug in forum Excel General
    Replies: 3
    Last Post: 12-04-2005, 03:10 PM
  8. Displaying Greatest to Least?
    By Losse in forum Excel General
    Replies: 2
    Last Post: 07-14-2005, 03:22 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1