Current location - Loan Platform Complete Network - Big data management - EXCEL first seek the average and then take the integer with ROUND?
EXCEL first seek the average and then take the integer with ROUND?
This is a class analogous to the calculation of personal income tax bracket formula, you need to provide the owner of the specific ratio and the corresponding amount, otherwise it is not good to analyze.

Another formula above can also be changed

=round(max(e3*{8,15,19,23,27,30}%-{0,560,1160,2360,4760,7760},0),2)