Thread: how to display answer as whole number and remainder
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ynot ynot is offline
external usenet poster
  
Posts: 1
Default how to display answer as whole number and remainder
I wanted to be able to divide one number by another and display the answer as
a whole number (not rounded up or down) and then the remainder in separate
cells so I can apply other formulas to the answers later. EG 6000 / 305 =
19 r 205
Reply With QuoteReply With Quote