I've tried =ROUNDDOWN(A5,2) and that doesn't work.

I'm working with two sets of numbers made up from two group of numbers. One set for example could be 75 + 80, and the next set may be 80 + 85. Then I need subtract the totals. From there I factor 80% of the difference then round down, and subtract that value from the highest number in the set that had the highest original sum.

For example in A49 I have =D49+D50 and in A50 I have =E49+E50, and A51 is =Max(A49:A50) and A52 is =MIN(A49:A50) and A53 is A51-A52. And A54 is A53*.8 set with two decimals.

What I'm needing to do is round A54 down. Then I need to subtract the value from the highest group number that made up cell A51. For example, if the sum of D49+D50 made up A51 then I need to be able to subtract the number that was rounded down from the higest number between D49 and D50

Clear as mud right? Hopefully someone can follow all this.