Results 1 to 5 of 5

Thread: Round down to nearest 5,000

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 08-11-2012, 08:15 AM #4
    mikerickson
    mikerickson is offline
    Mac Moderator VBAX Guru mikerickson's Avatar
    Joined
    May 2007
    Location
    Davis CA
    Posts
    2,776
    How about 
    =FLOOR(A1, 5000)
    Last edited by Aussiebear; 04-02-2025 at 01:04 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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