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.
 
P

p45cal

Dave said:
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.
Click to expand...

Ha Ha Ha Ha! How could I be so blind? I'm even beginning to think lik
a machine! :eek:
 
Top