+ Reply to Thread
Results 1 to 5 of 5

Help to Remove "Round" function from formula

  1. #1
    Registered User
    Join Date
    05-10-2013
    Location
    Michigan
    MS-Off Ver
    Excel 2010
    Posts
    8

    Help to Remove "Round" function from formula

    I'm having difficulty for some reason getting rid of my round function in this formula and figured someone on here could probably manage to do it in two seconds. Any help is appreciated. Below is the function;

    =IF(COUNT(D25:X25)>=7,ROUND(((((SUM(SMALL(INDEX(D25:X25,LARGE(IF(D25:X25<>"",COLUMN(D25:X25)-COLUMN(D25)+1),7)):X25,{2,3,4,5,6})))/5)-36)*0.9),0),IF(COUNT(D25:X25)>=3,ROUND((AVERAGE(D25:X25)-36)*0.9,0),IF(X25>=0,"NEW","ERROR")))

    I need to remove the round function so that my value contains additional digits.

    Thanks!

  2. #2
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: Help to Remove "Round" function from formula

    =if(count(d25:x25)>=7,((((sum(small(index(d25:x25,large(if(d25:x25<>"",column(d25:x25)-column(d25)+1),7)):x25,{2,3,4,5,6})))/5)-36)*0.9),if(count(d25:x25)>=3,(average(d25:x25)-36)*0.9,if(x25>=0,"new","error")))


    =IF(COUNT(D25:X25)>=7,ROUND(((((SUM(SMALL(INDEX(D25:X25,LARGE(IF(D25:X25<>"",COLUMN(D25:X25)-COLUMN(D25)+1),7)):X25,{2,3,4,5,6})))/5)-36)*0.9),0),IF(COUNT(D25:X25)>=3,ROUND((AVERAGE(D25:X25)-36)*0.9,0),IF(X25>=0,"NEW","ERROR")))

    Red bits removed
    Elegant Simplicity............. Not Always

  3. #3
    Registered User
    Join Date
    05-10-2013
    Location
    Michigan
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Help to Remove "Round" function from formula

    Thank you greatly Andy! I completely forgot about the ,0 to indicate the rounding amount. Thank you again!

  4. #4
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: Help to Remove "Round" function from formula

    You're welcome... Don't forget you can alternatively replace the 0 for the number of decimal places to display..It may be a better solution.
    Don't forget MROUND as an alternative as well.

  5. #5
    Registered User
    Join Date
    05-10-2013
    Location
    Michigan
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Help to Remove "Round" function from formula

    Hmm...wasn't aware of MRound. It isn't really what I was looking for in this case but can be used in a few other spreadsheets I've been playing with. Thanks for your help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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