close

I need to create a formula to select the next number in a series. For
example, if A1=175. I want the formula to result in the next number
divisible by 8 (=176). I'm sure it is pretty easy, but I don't know how to
make it work.=(TRUNC(A1/8) 1)*8

quot;Josh O.quot; wrote:

gt; I need to create a formula to select the next number in a series. For
gt; example, if A1=175. I want the formula to result in the next number
gt; divisible by 8 (=176). I'm sure it is pretty easy, but I don't know how to
gt; make it work.
gt;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄