Changing hundreds of prices with individual formulas takes time. SheetCommand can increase or decrease every value in a named numeric column by one percentage. A 10% increase turns 100 into 110; a 10% decrease turns 100 into 90.
Understand the calculation
For an increase, each value is multiplied by 1 + rate/100. For a decrease, the multiplier is 1 - rate/100. A 10% increase takes 250 to 275, while a 10% decrease takes 250 to 225.
Results are rounded to two decimal places. Only the named numeric column is updated. A source column containing currency symbols as text may not be recognized as numeric, so check how the data is stored before running the command.
Apply the change to your file
Upload the file and confirm that the heading is actually Price. Run the example command, then compare several original and processed values. Pay particular attention to low and high prices before downloading the new XLSX file.
For a reduction, ask to decrease 'Price' by 10%. To change values and then sort, connect the two supported steps with ‘then’; the preview reflects the final sequence.
How to do it
- Check that the target column is numeric and note its heading.
- Run Increase 'Price' by 10%.
- Compare old and new values before downloading.
Increase 'Price' by 10%Check a bulk update carefully
A rate of 10% is different from 0.10%. The command accepts decimal percentages, so read the number and percent sign once more before you submit it.
Blank cells in a numeric column remain blank. If prices are stored as text, the column may not be recognized as numeric at all. Compare the original and processed previews before using the exported file.
Frequently asked questions
Does a 10% decrease undo a previous 10% increase?
No. Increasing 100 to 110 and then decreasing 110 by 10% produces 99. Start again from the original file if you need to reverse a change.
Can I update several columns in one request?
Each step changes one named column. Connect separate steps with ‘then’ for several columns, or run them as separate requests.
SheetCommand
Try it on your file
Try the supported cleanup, sorting, and summary commands on your file. Use formula and script examples in their respective applications.