Snippets

def excel_round(num, decimals=0):
    """https://stackoverflow.com/a/78608344"""
    multiplier = 10**decimals
    if num >= 0:
        return int(num * multiplier + 0.5) / multiplier
    return int(num * multiplier - 0.5) / multiplier

num = 2.5
print(excel_round(num))

# output: 3.0