Excel 2016 error using Round

  Nosmas 17:24 05 Jun 2017
Locked

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.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Honor View 20 review

How Esports branding got a brand new look

Best free Mac apps

Les meilleurs VPN gratuits (2019)