roundings formula

  • Thread starter Thread starter Keiron James Keeble
  • Start date Start date
K

Keiron James Keeble

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
 
=rounddown(C3/b3,2)

Help can be your friend.

--

HTH

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with Rounding (2007) 4
#VALUE error add'g formulas 1
rounding up to nearest specified whole number 1
Rounding errors when a "5" is the third decimal place using formul 4
Excel Stop Excel from displaying rounded values 4
problem with round down 5
Excel Excel 2007 won't stop rounding down my formula results! 5
Round up & Autosum 1

Back
Top