If you want to become an Excel power user please check out our Excel Resources to learn all the most important functions, formulas, shortcuts, tips, and tricks. Thank you for reading CFI’s guide to the Excel ROUNDUP function. Here, I am attaching one sample format of Reconciliation Statement for matching of ITC (As shown in Return-3B) and ITC (As shown in Books of Accounts). As we know that In GST Audit, Reconciliation Statement is required.
In order to use the function, simply refer to cell B4 and any of cells D6 to D11 to specify the number of decimal places to include. Reconciliation Statement for Matching Of Input Tax Credit And Output Liability Between Books And Return. See the screenshot below for an example of the “roundup” function in action.Īs you can see in the table above, the number 58.68945 can be rounded to anywhere from 0 to 5 decimal pages. Step 3: type the number of units, or link to a cell that contains the number of units you want to display Step 2: link to the cell you want to round and add a comma
In this example, we show you how to create a table that uses the roundup formula to link to a number and then return a certain number of decimal places. The Excel roundup formula asks you to reference a specific number and then indicate how many units (decimal places) you want to round it to.
0 kommentar(er)
