Rounding Func

Location on ribbon: Tab DVD Addin → Group Formula → Menu Calculate Menu

Command ID: btnRoundingFunctions

What it does

This command wraps the formulas in the selected range with ROUND, ROUNDUP or ROUNDDOWN — or strips that wrapper back off. It edits the formulas themselves, not the display format, so the stored values really are rounded and downstream sums no longer drift by hidden decimals.

On acceptance records and payment applications, a few thousandths of difference caused by Excel keeping invisible decimals is one of the most common review findings. Wrapping a whole quantity column in ROUND settles it, and the same dialog unwraps it when you need the raw numbers back.

How to use

1. Select the range of cells whose formulas you want to change.
2. Go to tab DVD Addin → group Formula → menu Calculate Menu → click Rounding Func.
3. The Add or remove rounding window opens with three option blocks:
   • Action: Add function or Remove function.
   • Function: ROUND (round to nearest), ROUNDUP (round up), ROUNDDOWN (round down).
   • Decimal places (default 2) and the Skip hidden cells checkbox (on by default).
4. Pick the action, pick the function, type the number of decimal places you want.
5. Click Apply. The formulas in the selection are rewritten in place.
6. The window stays open: select another range and click Apply again, or click Close when finished.

Example

The concrete quantity column of an acceptance sheet, after selecting F10:F45 and applying Add function + ROUND + 2 decimals:

Before	After
=D10*E10	=ROUND(D10*E10,2)
=SUM(F11:F14)	=ROUND(SUM(F11:F14),2)
=B20*0.3*1.15	=ROUND(B20*0.3*1.15,2)

When you need the unrounded figures again to check against the drawings, reselect the range, switch to Remove function and click Apply.

Notes

• Only cells containing formulas are touched; hard-typed numbers are left alone.
• Decimal places applies to the Add function action; when removing, the existing rounding wrapper is stripped regardless of the number shown.
• Skip hidden cells leaves hidden or filtered-out rows and columns untouched — clear it if you want those processed too.
• The window is modeless: you can change the selection between Apply clicks, which is convenient but also makes it easy to apply to the wrong range.
• Formulas are overwritten and the change cannot be undone with Ctrl + Z — save the file before running it on a large sheet.

Related

• Lock Ref — the same style of window, adding or removing $ signs in formula references.
• Error Check — toggle Excel's formula error flags while reviewing the range you just edited.
• Fill Results — merge the rounded results into the description cells of a take-off sheet.