Thread: divide and round up
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
[email protected] dylanocuinn4@gmail.com is offline
external usenet poster
  
Posts: 1
Default divide and round up
=INT(D5/B4)+1


That wouldn't work if the result of the division is a whole number it would round up when it shouldn't


roundup is the one you'd want to use
Reply With QuoteReply With Quote