How can we achieve excel ceiling function with significance value in SQL Server

Question

How can we apply excel ceiling function with significance value in SQL server ?

=Ceiling(10,3)

it should return 12, because 12 is roundup nearest to 3

=Ceiling(36,7)

it should return 42, because 42 is roundup nearest to 7

Gordon Linoff · Answer 1 · 2021-08-21T11:30:19.983

2

You can use arithmetic:

select ceiling(10 * 1.0 / 3) * 3

The 1.0 is to avoid integer division. If the value is numeric or float, then it is not needed.

Here is a db<>fiddle.

edited Aug 21 '21 at 11:30

answered Aug 17 '21 at 12:13

Gordon Linoff

You could just do `ceiling(10 / 3.0) * 3` – Charlieface Aug 17 '21 at 13:35
@Charlieface . . . .The original values in the question don't have decimal points and iI didn't think it appropriate to change the values. – Gordon Linoff Aug 17 '21 at 22:08
with this formula, we get 10 but our answer should be 12 – Asfan Aug 21 '21 at 07:10
1

@Asfan . . . This answer cannot return `10` because that is not a multiple of `3`. I added a db<>fiddle to show that it works. – Gordon Linoff Aug 21 '21 at 11:30

1 Answers1