Always round up in calculation

[SITCFanTN]

I've reviewed the questions for rounding up but I'm not finding what I need
to help me to round in a calculation. My calculation is this

=Sum(Abs([RoomType]="Double"))/2

I always want the result to round up with no decimal place. Any help you
can give me is greatly appreciated. Thank you

 

[Evi]

I've reviewed the questions for rounding up but I'm not finding what I need
to help me to round in a calculation. My calculation is this

=Sum(Abs([RoomType]="Double"))/2

I always want the result to round up with no decimal place. Any help you
can give me is greatly appreciated. Thank you

=-Int(-(Sum(Abs([RoomType]="Double"))/2))


(there's a minus before Int and before the 2nd bracket)

Evi

 

[Rob Ward]

I may be missing something, but will this do
=iif(NumberToBeRounded=Int(NumberToBeRounded),NumberToBeRounded,int(NumberToBeRounded+1))