Correcting Rounding on a % formula

Hi please can someone help. I to calculate a % discount but am having rounding issues please you suggest fix

Creditors Name Amount Due Discount % Discount Amount Amount To Be Paid
????? R 3 591.00 2.5% R 89.78 R 3 501.2250 this figure is showing R3 501.23 with 2 decimal places

Formulas Number "=SUM(B5-E5)" "=B9*(1-2.5%)"

I need it to show R3501.22

Use round down
=ROUNDDOWN(E2,3)

Hi how would that look, I tried this and got and error? =ROUNDDOWN(B9*(1-2.5%,2))

thanks so much

Please close the Thread as "Resolved" (Thread tools).