View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

=rounddown(C3/b3,2)

Help can be your friend.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Keiron James Keeble" wrote in message
...
I have done a spreadsheet where I divid the number entered
in one cell by a number in a second cell the result being
eneter in the third cell. However I need to know how to
get the formula to round down this result to two decimal
places. Example cell D3 is the sum of C3/B3 but this needs
to be rounded down to two decimal places