Thread: Round up to next half number
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.newusers
daddylonglegs
 
Posts: n/a
Default Round up to next half number

For positive numbers

=ROUNDUP(A1*2,0)/2

does the same as

=CEILING(A1,0.5)

neither of them will return 4 when A1 is equal to 3.5, what result do
you want when A1 is 3?


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=525473

Reply With QuoteReply With Quote