Hi,

In this excel we Need macro or formula for round off amount.
It will always + or - .99 paisa from the total amount.
how can we calculate the rounding amount + or - from total amount.
Kindly advice.

Sub total 76,705.20
Transport
Cgst @ 9% 6,903.47
Sgst @9% 6,903.47
Round off (0.14)
Total Amount 90,512.00

Thanks and regards,
K.Srikanth