+ Reply to Thread
Results 1 to 2 of 2

Rounding up in formula

  1. #1
    Registered User
    Join Date
    11-09-2015
    Location
    Vancouver, BC
    MS-Off Ver
    2014
    Posts
    1

    Rounding up in formula

    I have tried all that I know to turn off the rounding up/down in this formula. Can anyone help?


    =IFERROR((MATCH(TRUE,SUBTOTAL(9,OFFSET(E845:$BB845,,,,COLUMN(E845:$BB845)-COLUMN(E845)+1))>E843,0)-1),">"&COUNTA(E845:$BB845))

    Thanks
    Last edited by TPBC; 11-10-2015 at 04:00 PM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Help with this formula

    Please adapt your thread title as per forum rules - Thx

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 11
    Last Post: 06-06-2014, 03:34 PM
  2. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1