Skip navigation

How do I make a (rounded up) value stick in another formula?

339 Views 2 Replies Latest reply: Jul 17, 2013 12:03 AM by Barry RSS
JayhawkCWE Calculating status...
Currently Being Moderated
Jul 16, 2013 11:43 AM

I don't even really know how to ask this question but I'm going to try.

 

The document is golf handicaps.  I have a formula that is figuring out the handicap in a column, then I have it rounding up to the nearest whole number.  In the next column, I have a formula that is dividing the value in the previous (handicap) column in half.  It works, it just takes the non-rounded value.  I need it to take the value that has been rounded up.  I'm thinking this has something to do with absolute numbers, but I can't figure it out.

 

Thanks in advance!

  • Barry Level 7 Level 7 (29,095 points)

    HI Jayhawk,

     

    Do you have any need to use the non-rounded value in further calculations? If not, you can do the rounding in that column. Just enclose the existing formula in C2 in a ROUNDUP statement:

     

    Current:  C2: =your formula

    Revised: C2: =ROUNDUP(your formula,0)

     

    Regards,

    Barry

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.