| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I combine 2 formulas? | New Users to Excel | |||
| Combine 2 formulas | Excel Worksheet Functions | |||
| Combine Formulas | Excel Discussion (Misc queries) | |||
| how to combine formulas to......... | Excel Worksheet Functions | |||
| Combine 2 formulas | Excel Worksheet Functions | |||
Threaded Mode
