Share via

Excel formula

Anonymous
2023-04-19T00:34:25+00:00

Hello,

I need help with figuring out a formula.

SF SF With waste Amount of Boxes Full boxes Total SF
9520 (cell K4) 10186.4 (cell L4) 377.27407 (cell M4) 378 (full box) (cell N4) 10206 (cell O4)

I'm trying to eliminate the highlighted column (M4). The highlighted box value currently is =L4/27 (which is the amount of SF per box). How do I merge M4 & N4 into one excel formula where one cell calculates the amount of boxes AND rounded up to the next full number.

Thanks in advance

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

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2023-04-20T07:09:55+00:00

    C2: =B2/A2-1

    Was this answer helpful?

    0 comments
  2. Anonymous
    2023-04-20T03:01:00+00:00

    Another question - how do I get the % formula in a cell for this?

    | | A | B | C | | 1 | Job Cost | Retail sale price | percentage of upcharge | | --- | --- | --- | --- | | 2 | $100 | $175 | =75% (need this formula) |

    Was this answer helpful?

    0 comments
  3. Anonymous
    2023-04-19T04:09:40+00:00

    Thank you!

    Was this answer helpful?

    0 comments
  4. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2023-04-19T03:52:49+00:00

    =ROUNDUP(L4/27,0)

    Was this answer helpful?

    0 comments