CELL A11 GROSS ` 3,976.15
CELL A12 Freight -
CELL A13 CGST 290.91
CELL A14 SGCT 290.91
CELL A15 Round Off -
CELL A16 TOTAL ` 4,557.98

THIS IS MY INVOICE FORMAT. I WANT ROUND OFF AMOUNT TO BE ADDED IN CELL A15 ,
ROUNDED OFF TO NEXT RUPEE IF TOTAL OF CELL A11:A14 IS ABOVE 0.50 PAISE,
ROUNDED OFF TO PREVIOUS RUPEE IF TOTAL OF CELL A11:A14 IS TILL 0.50 PAISE