Round Function

Originally Posted by joeu2004

You can also simplify, to wit:

=IF(VLOOKUP($B3, EmployeeMaster!$A:$L, 12, 0)="Y",
IF(SUM(V3:AA3)>SUM(P3:U3), 0, ROUND(MIN(CalculationBasics!$B$5, SUM(P3:U3))*CalculationBasics!$B$6%, 0)), 0)

Nicely done. I didnt even think to see if it could be simplified