Return the next and previous multiple of 1000.

[DouglasWicker]

Hello all.

I am looking for a way to find an integers (stored as a variable) nearest multiple of 1000's, both above and below.

For example, if a variables value is 5012, I would like to have 5000 and 6000 returned as two additional variables.

Any ideas?

 

[AlanY]

=ceiling(A1,1000)

and

=floor(A1,1000)

 

[DouglasWicker]

=ceiling(A1,1000)

and

=floor(A1,1000)

Thanks, that worked.

I had to use VariableUpper = worksheetfunction.ceiling(A1,1000) but worked the same.

 

[AlanY]

you're welcome