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.
 
Back
Top