Results 1 to 11 of 11

Excel Round down function

Threaded View

  1. #1
    Registered User
    Join Date
    12-09-2022
    Location
    London, UK
    MS-Off Ver
    Professional Plus 2013
    Posts
    5

    Question Excel Round down function

    A little tricky to explain, but I want to round down a XXX,XXX.XX to XXX so for example:
    ?465,003.18 =
    400
    ?439,702.19 = 400
    ?334,976.66 = 300
    ?268,572.22 = 200
    ?264,402.76 = 200
    ?182,103.14 = 100
    ?153,391.87 = 100
    ?124,811.24 = 100
    ?124,038.52 = 100

    There may be a better function, please see the attached spreadsheet. The income generated will dictate which club they rank, note: the club rank is always rounded down.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. round using round function vs the decrease decimal
    By lastnn30 in forum Excel General
    Replies: 3
    Last Post: 10-25-2021, 07:49 PM
  2. [SOLVED] How to PRESENT round-down, but not perform round-down function?
    By superlative in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-02-2019, 12:06 PM
  3. [SOLVED] VBA Round function output to Excel
    By juantsaplenty in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-01-2017, 10:23 AM
  4. Excel VBA Round-function
    By revanreal in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-18-2015, 07:45 AM
  5. Excel if or round function?
    By Jules5365 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-02-2008, 03:33 PM
  6. VB Function Round vs Excel function Round not behaving the same Od
    By Bud in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-18-2006, 12:45 AM
  7. [SOLVED] round function in excel 2000
    By lots of questions in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-03-2005, 10:06 PM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1