Excel Formula to Multiply by 1.53, Round Up, and Fill Down in WPS Office
Question details
The user needs a spreadsheet formula that multiplies each value in column D by 1.53, rounds the product up to the next whole dollar, and fills the result down through row 109.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- A user is working with a worksheet where column D contains original values and column E must contain calculated whole-dollar amounts from row 2 through row 109.
- Observed behavior
- The result in column E should be the value in column D multiplied by 1.53, rounded up to zero decimal places.
Open the workbook in WPS Office and confirm that the source values are in column D and that column E is available for the formula results.
Enter the ROUNDUP Formula in E2 and Fill Down Through E109
Use this when the multiplier 1.53 is fixed and you need the rounded-up whole-dollar result for each row.
The ROUNDUP function multiplies the value by 1.53 and rounds the product away from zero to zero decimal places, giving the next whole dollar. SUM is not required.
Click cell E2 in your WPS Office spreadsheet to make it the active cell.
Type =ROUNDUP(D2*1.53,0) in the formula bar and press Enter. If your system uses semicolon argument separators, type =ROUNDUP(D2*1.53;0).
Select E2, hover over the fill handle at the bottom-right corner, then drag down through cell E109. You can also select E2:E109 and press Ctrl+D.
Check that column E now displays each D value multiplied by 1.53 and rounded up to the next whole dollar.
Store the 1.53 Multiplier in a Cell and Reference It in the Formula
Use this when the multiplier may change later and you want to update one cell instead of editing many formulas.
Calculate Rounded-Up Values in WPS Office Spreadsheets
Use WPS Office Spreadsheets to enter the ROUNDUP formula in E2, multiply column D by 1.53, round up to the next whole dollar, and fill the formula down through row 109.
- 1. Open your workbook in WPS Spreadsheets: Launch WPS Office, open the workbook containing the values in column D, and click the spreadsheet tab where the results should appear.
- 2. Enter the formula in E2: Click E2 and type =ROUNDUP(D2*1.53,0) or =ROUNDUP(D2*1.53;0), then press Enter.
- 3. Fill down to row 109: Select E2, then drag the fill handle to E109 or select E2:E109 and press Ctrl+D.
- 4. Review rounded results: Confirm column E displays each column D value multiplied by 1.53 and rounded up to the next whole dollar.
Frequently Asked Questions
What formula rounds up the result of D2 multiplied by 1.53 in WPS Office?
Use =ROUNDUP(D2*1.53,0) in cell E2. On systems that use semicolon argument separators, use =ROUNDUP(D2*1.53;0).
How do I fill the formula down through row 109?
Select E2, then drag the fill handle down to E109. You can also select E2:E109 and press Ctrl+D to fill the formula.
Do I need SUM in the formula?
No, SUM is not required. Multiplying a single cell by a number only needs the * operator, and ROUNDUP handles the rounding.
How can I make the 1.53 multiplier easy to change later?
Put 1.53 in a cell such as F1 and use =ROUNDUP(D2*$F$1,0), then fill down. Update F1 to change all related results without editing each formula.
Does WPS Spreadsheets support Excel ROUNDUP formulas?
Yes, WPS Office Spreadsheets supports Excel-compatible formulas and .xlsx workbooks, including ROUNDUP and fill operations.
