Share via

Using ROUNDDOWN function on a cell with a formula already in it

Anonymous
2017-08-14T12:32:14+00:00

Using ROUNDDOWN function on a cell with a formula already in it

Trying to get the threefold damned Excel to round down the numbers I get with a =SUM formula.

Is there a way to do it without making multiple rows?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-08-17T08:29:25+00:00

    Hi Henry,

    Have you checked the information above?

    Please feel free to let us know the result.

    Thanks,

    Cherry

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2017-08-14T16:37:08+00:00

    Existing formula:

    =SUM(.....)

    New formula:

    =ROUNDDOWN(SUM(.....), x)

    where x is the number of digits - your choice on that.

    Was this answer helpful?

    0 comments