Solved Excel 2016 error using Round

[Nosmas]

The following formula gives the correct result for each of the conditions: -

=IF(GrosInc-PAIncLmt<0,EPA,IF(GrosInc-PAIncLmt-(EPA*2)>=0,0,EPA-(GrosInc-PAIncLmt)/2))

but if I introduce the Round function: -

=IF(GrosInc-PAIncLmt<0,EPA,IF(GrosInc-PAIncLmt-(EPA*2)>=0,0,Round(EPA-(GrosInc-PAIncLmt)/2),0))

in order for the result to be an integer, I get an error message "You've entered too few arguments for this function." Please can someone point out what I have done incorrectly.

 

[johnhoh]

Round(EPA-(GrosInc-PAIncLmt)/2),0))
should be this
Round(EPA-(GrosInc-PAIncLmt)/2,0)))

 

[Nosmas]

Many thanks johnhoh that has done the trick!!