How to Add 20 Percent and Round Up to 50 in Excel
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.

- 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.
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.
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.
Click on an empty cell where you want the calculated result to be displayed.
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.
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 CEILING Function
The CEILING function is specifically designed to round numbers up to a specified multiple, offering a simpler and more elegant formula.
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. Open your file in WPS Office: Launch WPS Spreadsheet and open the document containing your data.
- 2. Select the target cell: Click on the cell where you want the calculated result to be shown.
- 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.

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.




