Solved: Round up help in excel.

[quiff]

I am looking for some help with excel. I want to round a number up all the time.


Basically;


In Cell A1 I will be entering different number values.


In cell A2 I have the formula =(A1/350)+2


Now the problem I have is sometimes the number I get in cell A2 has a decimal place i.e, 7.37. However I want that number always rounded up so there are no decimal places. i.e, if 7.37 round up to 8, if 35.11 round up to 36.


Is there anyway to make this happen, once again I appreciate all help.


Thanks


Quiff

 

[cwwozniak]

You can use the ROUNDUP() function, with zero for the number of digits.

=ROUNDUP((A1/350)+2,0)

https://support.office.microsoft.co...68e-89a2-faf7e15c06ce&ui=en-US&rs=en-US&ad=US

 

[quiff]

Yeah that sorted it.


Thanks

 

[cwwozniak]

You're welcome.