Tally : Creating Auto Round Off Ledger Value in Excel : Simple, Secure and Smart Accounting

Tally : Creating Auto Round Off Ledger Value in Excel Print

Created by: Excel4Tally.com Excel4 Tally

Modified on: Mon, 12 Nov, 2018 at 12:59 PM

Tally : Creating Auto Round Off Ledger Value in Excel.

Please use following formula to set round off ledger value, it will automatically set round off based on your parameter.

=ROUND(BF2+BS2+BU2,0)-SUM(BF2,BS2,BU2)

Please find the attached Excel file with sample and example:

xlsx

(11.1 KB)

Excel4Tally.com is the author of this solution article.

Did you find it helpful? Yes No

Help Desk Software by Freshdesk