Always round up in calculation

  • Thread starter Thread starter SITCFanTN
  • Start date Start date
S

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
 
SITCFanTN said:
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
Click to expand...


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


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

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