How to stop last digit rounding up for percentage calculation

Hi I have a percentage calculation that I need to ensure excel does not round up the last digit.

My calculation is 2463000(cell:I13) divided by 257000(cell: I14+I15)
Excel calculates this value to be 0.958365759
However I need it to display and re-use only 0.9583657 as my calculation has to be precise to 7 decimal places.

If I use the formula =ROUND(I13/SUM(I14+I15),7) then excel returns the value 0.9583658 - it rounds the last digit up.

I have tried to use the option "Set precision as displayed" and set my decimal places to 7 but this still sees my 7th digit rounded up.
How do I set it so the 7th digit is not rounded up.

my original formaula is =IF(AND((L3+L8+L13)<=O3,(L3+L8+L13+L18)>O3),((O3-(L3+L8+L13))*I18/L18))
I have updated it to be =IF(AND((L3+L8+L13)<=O3,(L3+L8+L13+L18)>O3),((O3-(L3+L8+L13))*(ROUND(I18/L18,7))))

Any help would be appreciated

Trunc should work

=TRUNC(A1,7)

Hi all, thank you for your quick replies...
Jonmo1 your solution worked best.
Thank you...

hmm, conflicting reports
http://office.microsoft.com/en-us/ex...in=HP010079186

http://office.microsoft.com/en-us/ex...005209324.aspx

Originally Posted by Br0ther_bruce

Jonmo1 your solution worked best.

You're welcome.