ExcelBanter - Series Formula Help

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Series Formula Help (https://www.excelbanter.com/excel-worksheet-functions/63405-series-formula-help.html)

Josh O.

Series Formula Help

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.

Duke Carey

Series Formula Help

=(TRUNC(A1/8)+1)*8

"Josh O." wrote:

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.

All times are GMT +1. The time now is 10:04 PM.