Formula Errors

How to Add 20 Percent and Round Up to 50 in Excel

Natalie TaylorNatalie Taylor Oct 22, 2026 873 views

Question details

The user needs to calculate a 20% increase on a specific value and simultaneously round the final result up to the nearest multiple of 50.

How to Add 20 Percent and Round Up to 50 in Excel
Product
Excel
Device & OS
not provided
Scenario
Calculating prices, estimating inventory, or setting margins where a 20% markup is applied, and the final number must be standardized to a specific tier (nearest 50).
Observed behavior
The goal is to accurately calculate the markup and apply custom rounding logic within a single spreadsheet formula.
Before you start

Ensure your base value is located in a single cell (e.g., N7) and formatted as a numerical value, as formulas will return errors if applied to text.

Solution 1Recommended

Use the ROUNDUP Function

Manually divide and multiply by 50 within the ROUNDUP function to force the calculation to the nearest multiple.

The ROUNDUP function rounds numbers away from zero. By dividing your marked-up value by 50, rounding it to zero decimal places, and then multiplying it back by 50, you create a custom multiple roundup.

1
Select the target cell

Click on an empty cell where you want the calculated result to be displayed.

2
Enter the formula

Type the formula =ROUNDUP(N7*120%/50,0)*50 into the formula bar. Replace 'N7' with the actual cell reference that contains your base value.

3
Apply the calculation

Press the Enter key. The formula will first increase the value by 20 percent, divide it by 50, round the result up to the nearest whole number, and multiply it by 50 to get the final rounded tier.

Use the ROUNDUP Function
Alternative Percentage Formats: Instead of using '120%', you can also use '1.2' in your formula, like this: =ROUNDUP(N7*1.2/50,0)*50.
Free Spreadsheet Software

Calculate and Round Up Formulas Easily with WPS Office

WPS Spreadsheet fully supports all standard Excel functions, including ROUNDUP and CEILING. You can manage complex calculations, apply precise price markups, and build detailed rounding rules seamlessly in a familiar interface.

  1. 1. Open your file in WPS Office: Launch WPS Spreadsheet and open the document containing your data.
  2. 2. Select the target cell: Click on the cell where you want the calculated result to be shown.
  3. 3. Apply the calculation: Type =CEILING(A1*1.2, 50) (replace A1 with your target cell) and press Enter to instantly get your marked-up and rounded number.
Fully compatible with Microsoft Excel formulas and .xlsx files.Process advanced markup and rounding calculations smoothly.Built-in function library with detailed syntax guides to prevent errors.Lightweight, free-to-use software with a user-friendly tabbed workspace.
microsoft office alternative - wps office

Frequently Asked Questions

Can I round down to the nearest 50 instead of rounding up?

Yes, you can use the FLOOR function for this. Simply change your formula to =FLOOR(N7*1.2, 50) or use the ROUNDDOWN equivalent: =ROUNDDOWN(N7*120%/50,0)*50 to round the result down to the nearest multiple.

How do I adjust the formula to add a different percentage?

To add a different percentage, adjust the multiplier in your formula. For example, to add 15%, you should multiply by 1.15 (or 115%) instead of 1.2. The new formula would be =CEILING(N7*1.15, 50).

Why does my roundup formula return a #VALUE! error?

This error occurs when the cell you are referencing contains non-numerical data. Ensure the base cell does not contain text characters, hidden spaces, or incorrectly formatted currency symbols.

What is the difference between the CEILING and ROUNDUP functions?

The CEILING function directly rounds a number up to a specified multiple (like 50 or 100), making it ideal for tiering prices or inventory. The ROUNDUP function, on the other hand, rounds a number up to a specified number of decimal places, which requires manual division and multiplication to mimic the multiple-tiering behavior.