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: