Combine Formulas

  • Thread starter Thread starter Canon
  • Start date Start date
C

Canon

Excel 2007
I have a simple formula; =sum(E3/22.40), and I would like to combine the
FLOOR function together with this so that the answer rounds down.
4.4689 should round down to 4.25
 
Since you're not summing anything, the =sum() portion isn't required.

=e3/22.40
is sufficient

so
=floor(e3/22.40,.25)

should work ok.
 

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

Different kind of rounding 4
Round formula 1
Rounding and Multiplying 3
Round to nearest multiple 3
Converting a decimal number into time 7
Sum + Round Up 2
Formula Help 1
ROUNDING UP TO NEAREST 9 4

Back
Top