ExcelBanter - Combine Formulas

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Combine Formulas (https://www.excelbanter.com/excel-discussion-misc-queries/246468-combine-formulas.html)

Canon

Combine Formulas

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

Dave Peterson

Combine Formulas

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.

Canon wrote:

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

--

Dave Peterson

All times are GMT +1. The time now is 03:15 AM.