Combine Formulas

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
 
D

Dave Peterson

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

Round formula 1
Joining Two formulas with the Help of AND / OR / IF Functions to getthe desired result 1
Formulas 3
Round Down to the nearest multiple 2
Conditional Formatting and Formulas 1
Different kind of rounding 4
text & formual problem combined 5
how do i combine excel worksheets 1

Top