Thread: Rounding Off!?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Trevor Shuttleworth
 
Posts: n/a
Default Rounding Off!?

OK

=ROUNDUP(A1/B1,0)

Regards

Trevor


"Neo1" wrote in message
...

The thing is i want to round up the number once it has been divided for
example:

=A1/B1

I want to put that formula on C1 and the number I get there i want to
round it up to the upper number which means if i get say 13.2 i want it
to go to 14 not to 13 for example

From John
Thanks


--
Neo1
------------------------------------------------------------------------
Neo1's Profile:
http://www.excelforum.com/member.php...o&userid=30329
View this thread: http://www.excelforum.com/showthread...hreadid=520843